Search found 1820 matches

by JimKnicely
Tue Sep 25, 2018 2:50 pm
Forum: Announcements, Events and Activities
Topic: Subscribe to the Vertica newsletter!
Replies: 0
Views: 9

Subscribe to the Vertica newsletter!

Vertica Insights Newsletter

Sign up below to receive monthly updates and articles about Vertica!

http://go.microfocus.com/vertica-newsletter-subscribe
by JimKnicely
Tue Sep 25, 2018 2:35 pm
Forum: Vertica Links
Topic: Vertica Tip: Changing the Owner of a View
Replies: 0
Views: 21

Vertica Tip: Changing the Owner of a View

We can change the owner of a database view with the ALTER VIEW … OWNER TO command.

Read more here:
https://forum.vertica.com/discussion/23 ... -of-a-view
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: 22

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

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

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

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

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

Go to advanced search