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.

Vertica Community Guidelines

Announcement JAvila 666 views 1 comment 2 points Most recent by rahulpanda95 February 22
When was the last time you've checked your OS vulnerability?

Announcement mosheg 68 views 0 comments 0 points Started by mosheg October 2019
Vertica tip: are your columns too wide?

Bryan_H 81 views 1 comment 1 point Most recent by Anonymous_Wombat 7:59PM
Define a Vertica Flattened Table Column as Having Both DEFAULT and SET USING Constraints

Jim_Knicely 31 views 0 comments 0 points Started by Jim_Knicely January 29
Loading ZIP code boundaries from a shapefile in three easy steps!

Bryan_H 30 views 0 comments 0 points Started by Bryan_H January 29
Base64 decode/encode functions in Vertica (via Python UDX-SDK)

SergeB 58 views 0 comments 0 points Started by SergeB January 27
Viewing Parquet Export Events More Easily

Jim_Knicely 27 views 0 comments 0 points Started by Jim_Knicely January 27
Which Database Mode is My Database Using?

Jim_Knicely 34 views 1 comment 0 points Most recent by Abhishek_Rana January 22
Moving a Table to a New Schema and Inherting the New Schema Privileges

Jim_Knicely 60 views 0 comments 0 points Started by Jim_Knicely December 2019
Working with Python and R in Vertica

Bryan_H 88 views 0 comments 0 points Started by Bryan_H December 2019
Summarize the Values in a String

Jim_Knicely 76 views 0 comments 0 points Started by Jim_Knicely November 2019
Latest Vertica patches available

Vertiguy 75 views 0 comments 0 points Started by Vertiguy November 2019
Query spends more time on before plan

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

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

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

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

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

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

Jim_Knicely 64 views 0 comments 0 points Started by Jim_Knicely October 2019
Parallel processing using partitions with Vertica UDx

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

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

Bryan_H 65 views 0 comments 1 point Started by Bryan_H October 2019
Tracking Raw Schema Size Over Time

Jim_Knicely 64 views 0 comments 0 points Started by Jim_Knicely September 2019
Have VSQL Beep Upon Command Completion

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

Jim_Knicely 50 views 0 comments 0 points Started by Jim_Knicely September 2019
Investigate Data Collector Table Data Produced by a Scrutinize

Jim_Knicely 73 views 0 comments 1 point Started by Jim_Knicely September 2019
Load Data Enclosed By and Embedded With Double Quotes

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

Question Jim_Knicely 90 views 0 comments 1 point Started by Jim_Knicely August 2019
Stop a Stubborn Query that Won’t Cancel

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

Jim_Knicely 117 views 0 comments 0 points Started by Jim_Knicely August 2019