Welcome to the Vertica Forum

Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

Tips from the Team

Announcements, news, and tips from Vertica employees.

Vertica Community Guidelines

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

Announcement mosheg 259 views 0 comments 1 point Started by mosheg October 2019
Split a string into parts

SarahL 1.7K views 2 comments 1 point Most recent by marcothesane November 20
Have VSQL Beep Upon Command Completion

Jim_Knicely 241 views 2 comments 1 point Most recent by carl125 November 3
recovery failing after power outage

Question bertramf 86 views 0 comments 0 points Started by bertramf October 8
Re-IP - Checking All IP Addresses when Changing Using Re-IP

Amaksh 79 views 0 comments 0 points Started by Amaksh September 30
Using Access Policies in Vertica to Hide Sensitive Data

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

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

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

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

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

Answered mosheg 190 views 1 comment 1 point Most recent by sahil_kumar May 29
Replacing the Host With New IP Address

Amaksh 302 views 0 comments -1 point Started by Amaksh May 11
Rebuilding the Host With the Same IP Address

Amaksh 256 views 0 comments 1 point Started by Amaksh May 11
Checking the Validity of a Table Audit

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

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

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

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

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

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

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

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

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

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

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

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

Jim_Knicely 259 views 0 comments 1 point Started by Jim_Knicely October 2019