Welcome to the Vertica Forum

The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.

Tips from the Team

Announcements, news, and tips from Vertica employees.

When was the last time you've checked your OS vulnerability?

Announcement mosheg 16 views 0 comments 0 points Started by mosheg October 15
Vertica Community Guidelines

Announcement JAvila 415 views 0 comments 2 points Started by JAvila August 13
Moving a Table to a New Schema and Inherting the New Schema Privileges

Jim_Knicely 5 views 0 comments 0 points Started by Jim_Knicely December 6
Working with Python and R in Vertica

Bryan_H 13 views 0 comments 0 points Started by Bryan_H December 4
Summarize the Values in a String

Jim_Knicely 26 views 0 comments 0 points Started by Jim_Knicely November 20
Vertica tip: are your columns too wide?

Bryan_H 21 views 0 comments 0 points Started by Bryan_H November 13
Latest Vertica patches available

Vertiguy 13 views 0 comments 0 points Started by Vertiguy November 12
Query spends more time on before plan

Answered VigneshN 26 views 3 comments 0 points Most recent by emoreno November 12
Checking and improving column compression and encoding

Bryan_H 30 views 1 comment 0 points Most recent by Sharon_Cutter November 11
How To get OS/kernel version in Vertica catalog tables

Answered Vertiguy 44 views 2 comments 1 point Most recent by ChuckB November 8
Vertica 9.3 Supports UPDATE and DELETE Operations on Tables Having Live Aggregate Projections!

Jim_Knicely 24 views 2 comments 1 point Most recent by Jim_Knicely October 25
DIRECT Is Now the Default Load Type

Jim_Knicely 24 views 2 comments 0 points Most recent by Jim_Knicely October 25
How to alter a column data type from numeric(3,2) to numeric(5,4) in Vertica

Answered Vertiguy 44 views 1 comment 0 points Most recent by hsaxena20 October 23
Get the Row Count from an Outer Table Join

Jim_Knicely 15 views 0 comments 0 points Started by Jim_Knicely October 21
Parallel processing using partitions with Vertica UDx

Bryan_H 26 views 0 comments 1 point Started by Bryan_H October 14
Extending Vertica with Python functions: adding NumPy FFT as a UDx

Bryan_H 35 views 0 comments 1 point Started by Bryan_H October 10
Finding the "K" in K-means clustering with a UDx

Bryan_H 17 views 0 comments 1 point Started by Bryan_H October 3
Tracking Raw Schema Size Over Time

Jim_Knicely 16 views 0 comments 0 points Started by Jim_Knicely September 25
Have VSQL Beep Upon Command Completion

Jim_Knicely 12 views 1 comment 0 points Most recent by LenoyJ September 7
Easy Development Schema Cleanup (i.e. Have Vertica Drop a Bunch of Tables for You)

Jim_Knicely 4 views 0 comments 0 points Started by Jim_Knicely September 7
Investigate Data Collector Table Data Produced by a Scrutinize

Jim_Knicely 16 views 0 comments 0 points Started by Jim_Knicely September 4
Load Data Enclosed By and Embedded With Double Quotes

Jim_Knicely 16 views 0 comments 0 points Started by Jim_Knicely September 4
Make a Cow Display Query Results in VSQL

Question Jim_Knicely 33 views 0 comments 0 points Started by Jim_Knicely August 16
Stop a Stubborn Query that Won’t Cancel

Answered Jim_Knicely 136 views 2 comments 0 points Most recent by Jim_Knicely August 16
Change Your User Password in VSQL with a Meta-Command

Jim_Knicely 66 views 0 comments 0 points Started by Jim_Knicely August 13
View the History of Connection Load Balance Operations

Jim_Knicely 49 views 0 comments 0 points Started by Jim_Knicely August 9
Load Balance Older Clients (That You Can’t Upgrade for Some Weird Reason)

Jim_Knicely 16 views 0 comments 0 points Started by Jim_Knicely August 8
Testing the Native Load Balancer

Jim_Knicely 15 views 0 comments 0 points Started by Jim_Knicely August 7
Diving into disk usage

Bryan_H 27 views 0 comments 0 points Started by Bryan_H August 6
Find and fix issues from Vertica query events

Bryan_H 41 views 0 comments 0 points Started by Bryan_H August 5