Search found 1823 matches

by JimKnicely
Fri Oct 19, 2018 5:05 pm
Forum: Announcements, Events and Activities
Topic: Tableau Conference – New Orleans, LA
Replies: 0
Views: 23

Tableau Conference – New Orleans, LA

Tableau Conference – New Orleans, LA Vertica will be a Megabyte Sponsor at the upcoming Tableau Conference October 22 – 25th in New Orleans. Thousands of analytics-obsessed attendees from every industry and discipline will be there, hungry for solutions to help them leverage their investment in Tab...
by JimKnicely
Thu Sep 27, 2018 4:46 pm
Forum: General
Topic: change active partition (v8.1.1)
Replies: 3
Views: 542

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

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

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

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

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

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

Go to advanced search