Search found 1825 matches
- Mon Sep 17, 2018 1:24 pm
- Forum: Announcements, Events and Activities
- Topic: Vertica is Coming to Pittsburgh on September 20!
- Replies: 0
- Views: 13371
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 ...
- Wed Sep 12, 2018 6:59 pm
- Forum: Vertica Links
- Topic: Vertica Tip: Analyzing Table Statistics by Column
- Replies: 0
- Views: 15277
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 ...
- Wed Sep 12, 2018 6:54 pm
- Forum: Vertica Links
- Topic: Vertica Tip: The system table for system tables
- Replies: 0
- Views: 15211
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
Find out more here:
https://forum.vertica.com/discussion/23 ... tem-tables
- Wed Sep 12, 2018 6:50 pm
- Forum: Vertica Links
- Topic: Vertica Tip: Sampling data from a large dataset using TABLESAMPLE
- Replies: 0
- Views: 15311
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
Find out how to use it here:
https://forum.vertica.com/discussion/23 ... ablesample
- Wed Sep 05, 2018 1:04 pm
- Forum: Vertica SQL
- Topic: Convert PostgreSQL script to Vertica
- Replies: 2
- Views: 47340
Re: Convert PostgreSQL script to Vertica
Hi,
Please follow the thread here per this topic!
https://forum.vertica.com/discussion/23 ... ica#latest
Thanks!
Please follow the thread here per this topic!
https://forum.vertica.com/discussion/23 ... ica#latest
Thanks!
- Sun Jul 29, 2018 2:45 pm
- Forum: Vertica Security
- Topic: Objects invisible to users when NOT created by dbadmin
- Replies: 2
- Views: 47862
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...
- Mon Jul 23, 2018 6:57 pm
- Forum: Vertica Links
- Topic: Big Data and Machine Learning London Meetup: The Movie!
- Replies: 0
- Views: 15165
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
https://www.youtube.com/watch?time_continue=31&v=EqER7Y74TII