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 192 views 0 comments -1 point Started by Amaksh May 11
Rebuilding the Host With the Same IP Address

Announcement Amaksh 180 views 0 comments 1 point Started by Amaksh May 11
Vertica Community Guidelines

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

Announcement mosheg 198 views 0 comments 1 point Started by mosheg October 2019
Using Access Policies in Vertica to Hide Sensitive Data

Amaksh 25 views 0 comments 0 points Started by Amaksh September 15
Database Storage - Raw and Compressed Size

Jim_Knicely 597 views 1 comment 1 point Most recent by yalin September 15
How to Create a Database with Desired Node Names

Amaksh 38 views 0 comments 0 points Started by Amaksh August 27
Enable \timing from the vsql Command Line

SarahL 591 views 4 comments 0 points Most recent by Jim_Knicely August 13
How to know what is killing Vertica process

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

Answered mosheg 130 views 1 comment 1 point Most recent by sahil_kumar May 29
Checking the Validity of a Table Audit

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

Bryan_H 280 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 158 views 0 comments 1 point Started by Jim_Knicely January 29
Loading ZIP code boundaries from a shapefile in three easy steps!

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

SergeB 279 views 0 comments 1 point Started by SergeB January 27
Viewing Parquet Export Events More Easily

Jim_Knicely 170 views 0 comments 1 point Started by Jim_Knicely January 27
Which Database Mode is My Database Using?

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

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

Bryan_H 271 views 0 comments 1 point Started by Bryan_H December 2019
Summarize the Values in a String

Jim_Knicely 230 views 0 comments 1 point Started by Jim_Knicely November 2019
Query spends more time on before plan

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

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

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

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

Jim_Knicely 217 views 2 comments -1 point 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 347 views 1 comment 1 point Most recent by hsaxena20 October 2019
Get the Row Count from an Outer Table Join

Jim_Knicely 201 views 0 comments 1 point Started by Jim_Knicely October 2019
Parallel processing using partitions with Vertica UDx

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

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

Bryan_H 192 views 0 comments -1 point Started by Bryan_H October 2019