Search found 1824 matches

by JimKnicely
Sat Nov 17, 2018 1:05 pm
Forum: Vertica Links
Topic: Master Blog Series: Vertica Database Administrators
Replies: 0
Views: 333

Master Blog Series: Vertica Database Administrators

Are you a database administrator looking for ways to get the most from your Vertica database? If so, this post is for you. You’re already familiar with the technicalities of Vertica – the Tuple Mover, deletes, projections, and more. If you’re looking to get started, check out our master blog for new...
by JimKnicely
Fri Oct 19, 2018 5:05 pm
Forum: Announcements, Events and Activities
Topic: Tableau Conference – New Orleans, LA
Replies: 0
Views: 2677

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: 4
Views: 888

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

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

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

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

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

Go to advanced search