Search found 1825 matches
- Tue Sep 25, 2018 2:33 pm
- Forum: Vertica Links
- Topic: Vertica Tip: Setting Variables on the VSQL Command Line
- Replies: 0
- Views: 34227
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...
- Sat Sep 22, 2018 2:32 pm
- Forum: Vertica Links
- Topic: Vertica Tip: Setting the Table-Level Active Partition Count
- Replies: 0
- Views: 34009
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 ...
- Sat Sep 22, 2018 2:27 pm
- Forum: Vertica Links
- Topic: Vertica Tip: Enabling Inter-Node Spread Encryption
- Replies: 0
- Views: 34275
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...
- 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: 13761
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...
- Thu Sep 20, 2018 2:27 pm
- Forum: Vertica Links
- Topic: Vertica Tip: Exiting a DbVisualizer Script Following an Error
- Replies: 0
- Views: 14941
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,...
- Thu Sep 20, 2018 2:26 pm
- Forum: Vertica Links
- Topic: Vertica Tip: Exiting a vsql Script Following an Error
- Replies: 0
- Views: 14645
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://...
- Thu Sep 20, 2018 2:24 pm
- Forum: Vertica Links
- Topic: Vertica Tip: Enabling Inter-Node Spread Encryption
- Replies: 0
- Views: 14450
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...