Search found 1822 matches

by JimKnicely
Thu Sep 27, 2018 4:46 pm
Forum: General
Topic: change active partition (v8.1.1)
Replies: 3
Views: 525

Re: change active partition (v8.1.1)

Hi, You can now set the Active Partition Count at the table level. See: https://www.vertica.com/docs/9.1.x/HTML/index.htm#Authoring/AdministratorsGuide/Partitions/ActivePartitions.htm From the doc: Note: For tables partitioned by non-temporal attributes, set its active partition count to reflect the...
by JimKnicely
Wed Sep 26, 2018 4:06 pm
Forum: Vertica Links
Topic: Vertica Tip: Display the Current Statement Number Within the Current Transaction
Replies: 0
Views: 64

Vertica Tip: Display the Current Statement Number Within the Current Transaction

A Transaction in Vertica is one or more operations that are executed as a unit of work. At the user level, transactions occur in the current session by a user or script running one or more SQL statements. A transaction has a unique Transaction ID and the “units of work” within a transaction are each...
by JimKnicely
Tue Sep 25, 2018 2:50 pm
Forum: Announcements, Events and Activities
Topic: Subscribe to the Vertica newsletter!
Replies: 0
Views: 66

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

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

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

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

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

Go to advanced search