Search found 1824 matches

by JimKnicely
Wed Sep 12, 2018 6:59 pm
Forum: Vertica Links
Topic: Vertica Tip: Analyzing Table Statistics by Column
Replies: 0
Views: 197

Vertica Tip: Analyzing Table Statistics by Column

The ANALYZE_STATISTICS function collects and aggregates data samples and storage information from all nodes that store projections associated with the specified table. On a very large wide table, it takes a significant amount of time to gather those statistics. In many situations only a few columns ...
by JimKnicely
Wed Sep 12, 2018 6:54 pm
Forum: Vertica Links
Topic: Vertica Tip: The system table for system tables
Replies: 0
Views: 196

Vertica Tip: The system table for system tables

Did you know that there’s a system table that contains information about all of Vertica’s system tables?

Find out more here:

https://forum.vertica.com/discussion/23 ... tem-tables
by JimKnicely
Wed Sep 12, 2018 6:50 pm
Forum: Vertica Links
Topic: Vertica Tip: Sampling data from a large dataset using TABLESAMPLE
Replies: 0
Views: 208

Vertica Tip: Sampling data from a large dataset using TABLESAMPLE

In order to provide a true sampling of the entire data set, Vertica provides the TABLESAMPLE clause.

Find out how to use it here:

https://forum.vertica.com/discussion/23 ... ablesample
by JimKnicely
Wed Sep 05, 2018 1:04 pm
Forum: Vertica SQL
Topic: Convert PostgreSQL script to Vertica
Replies: 2
Views: 2261

Re: Convert PostgreSQL script to Vertica

Hi,

Please follow the thread here per this topic!

https://forum.vertica.com/discussion/23 ... ica#latest

Thanks!
by JimKnicely
Sun Jul 29, 2018 2:45 pm
Forum: Vertica Security
Topic: Objects invisible to users when NOT created by dbadmin
Replies: 2
Views: 2240

Re: Objects invisible to users when NOT created by dbadmin

Check out the "Privileges Required for Common Database Operations" doc. In particular, the "Object Visibility" section: Here: https://my.vertica.com/docs/9.1.x/HTML/index.htm#Authoring/AdministratorsGuide/Security/DBUsersAndPrivileges/PrivilegesRequiredForCommonDatabaseOperations.htm Example: dbadmi...
by JimKnicely
Mon Jul 23, 2018 6:57 pm
Forum: Vertica Links
Topic: Big Data and Machine Learning London Meetup: The Movie!
Replies: 0
Views: 271

Big Data and Machine Learning London Meetup: The Movie!

Vertica's own Mark Whalley talks about the advantages of a columnar database like Vertica for analytics and machine learning, and provides some use cases in fashion and retail to show how it works.

https://www.youtube.com/watch?time_continue=31&v=EqER7Y74TII
by JimKnicely
Mon Jun 04, 2018 1:22 pm
Forum: General
Topic: Primary Key Constraints
Replies: 8
Views: 1146

Re: Primary Key Constraints

Oops... I put the email address! Sorry!

Here is the correct email address:

james.knicely@microfocus.com

Go to advanced search