Search found 1811 matches

by JimKnicely
Mon Sep 17, 2018 1:24 pm
Forum: Announcements, Events and Activities
Topic: Vertica is Coming to Pittsburgh on September 20!
Replies: 0
Views: 27

Vertica is Coming to Pittsburgh on September 20!

Vertica is looking for outstanding software engineers, QA engineers, and technical writers. We are hiring full-time employees and summer 2019 interns in our Cambridge, MA and Pittsburgh, PA offices. You’ll have the opportunity to add your innovative ideas to our flagship product, massively scalable ...
by JimKnicely
Wed Sep 12, 2018 6:59 pm
Forum: Vertica Links
Topic: Vertica Tip: Analyzing Table Statistics by Column
Replies: 0
Views: 44

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: 41

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: 45

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: 175

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: 234

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: 123

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

Go to advanced search