Welcome to the Vertica Forum

Tips from the Team

Announcements, news, and tips from Vertica employees.

Replacing the Host With New IP Address

Announcement Amaksh 104 views 0 comments 0 points Started by Amaksh May 11
Rebuilding the Host With the Same IP Address

Announcement Amaksh 92 views 0 comments 0 points Started by Amaksh May 11
Vertica Community Guidelines

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

Announcement mosheg 117 views 0 comments 0 points Started by mosheg October 2019
How to know what is killing Vertica process

Amaksh 39 views 2 comments 2 points Most recent by Hibiki July 1
How to delete the oldest partition?

Answered mosheg 44 views 1 comment 0 points Most recent by sahil_kumar May 29
Checking the Validity of a Table Audit

Jim_Knicely 468 views 10 comments 1 point Most recent by Sankarmn May 1
Vertica tip: are your columns too wide?

Bryan_H 166 views 1 comment 1 point Most recent by Anonymous_Wombat April 8
Define a Vertica Flattened Table Column as Having Both DEFAULT and SET USING Constraints

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

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

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

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

Jim_Knicely 84 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 108 views 0 comments 0 points Started by Jim_Knicely December 2019
Working with Python and R in Vertica

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

Jim_Knicely 137 views 0 comments 0 points Started by Jim_Knicely November 2019
Query spends more time on before plan

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

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

Answered Vertiguy 135 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 189 views 2 comments 1 point Most recent by Jim_Knicely October 2019
DIRECT Is Now the Default Load Type

Jim_Knicely 127 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 201 views 1 comment 0 points Most recent by hsaxena20 October 2019
Get the Row Count from an Outer Table Join

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

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

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

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

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

Jim_Knicely 97 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 97 views 0 comments 0 points Started by Jim_Knicely September 2019
Investigate Data Collector Table Data Produced by a Scrutinize

Jim_Knicely 121 views 0 comments 1 point Started by Jim_Knicely September 2019