Search found 1817 matches

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

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

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

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

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

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

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

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

Go to advanced search