Search found 1825 matches

by JimKnicely
Tue Sep 25, 2018 2:33 pm
Forum: Vertica Links
Topic: Vertica Tip: Setting Variables on the VSQL Command Line
Replies: 0
Views: 1681

Vertica Tip: Setting Variables on the VSQL Command Line

The vsql client provides variable substitution features similar to common Linux command shells. Variables are name/value pairs, where the value can be a string of any length. The -v, --variable, and --set options can be used to set a variables value from the command line. Read more here: https://for...
by JimKnicely
Sat Sep 22, 2018 2:32 pm
Forum: Vertica Links
Topic: Vertica Tip: Setting the Table-Level Active Partition Count
Replies: 0
Views: 1567

Vertica Tip: Setting the Table-Level Active Partition Count

The Tuple Mover assumes that all loads and updates to a partitioned table are targeted to one or more partitions that it identifies as active. In general, the partitions with the largest partition keys—typically, the most recently created partitions—are regarded as active. As the partition ages, it ...
by JimKnicely
Sat Sep 22, 2018 2:27 pm
Forum: Vertica Links
Topic: Vertica Tip: Enabling Inter-Node Spread Encryption
Replies: 0
Views: 1604

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. The EncryptSpreadComm configuration parameter enables encryption on the control channe...
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: 1081

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

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

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

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...

Go to advanced search