Search found 1815 matches

by JimKnicely
Thu Sep 20, 2018 2:36 pm
Forum: Announcements, Events and Activities
Topic: Using advanced analytics to help farmers optimize resources and maximize yield (Webinar)
Replies: 0
Views: 27

Using advanced analytics to help farmers optimize resources and maximize yield (Webinar)

About this Webinar: The Climate Corporation aims to help the world's farmers sustainably increase their productivity with digital tools. The integrated Climate FieldView™ digital agriculture platform provides farmers with one comprehensive, connected suite of digital tools to help them optimize reso...
by JimKnicely
Thu Sep 20, 2018 2:27 pm
Forum: Vertica Links
Topic: Vertica Tip: Exiting a DbVisualizer Script Following an Error
Replies: 0
Views: 18

Vertica Tip: Exiting a DbVisualizer Script Following an Error

After reading yesterday’s Vertica Quick Tip “Exiting a vsql Script Following an Error”, a client asked if the ON_ERROR_STOP variable is available in the popular third party Vertica client tool DbVisualizer. The answer to that is no as ON_ERROR_STOP is a Vertica vsql client specific setting. However,...
by JimKnicely
Thu Sep 20, 2018 2:26 pm
Forum: Vertica Links
Topic: Vertica Tip: Exiting a vsql Script Following an Error
Replies: 0
Views: 25

Vertica Tip: Exiting a vsql Script Following an Error

By default, if a vsql script command results in an error, for example, because of a malformed command or invalid data format, processing continues. If you set ON_ERROR_STOP to “on” in a vsql script and an error occurs during processing, the script terminates immediately. Find out more here: https://...
by JimKnicely
Thu Sep 20, 2018 2:24 pm
Forum: Vertica Links
Topic: Vertica Tip: Enabling Inter-Node Spread Encryption
Replies: 0
Views: 22

Vertica Tip: Enabling Inter-Node Spread Encryption

Internode SSL allows you to use SSL to secure communication between nodes within a Vertica cluster. It is important to secure communications between Vertica nodes if you do not trust the network between the nodes. Find out more here: https://forum.vertica.com/discussion/239936/enabling-inter-node-sp...
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: 29

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

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

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

Go to advanced search