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

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.

How to convert numeric value stored in histogram data to timestamp

Announcement Hibiki 345 views 0 comments 0 points Started by Hibiki July 2021
When was the last time you've checked your OS vulnerability?

Announcement mosheg 923 views 0 comments 1 point Started by mosheg October 2019
How to make auto start Vertica DB after reboot vertica node in vertica version 12.0

Answered Closed navaneet 293 views 1 comment -5 points Most recent by SruthiA March 15
SQL Reserved Words

[Deleted User] 1.7K views 2 comments 1 point Most recent by marcothesane February 10
Accessing external files in an encrypted zone on HDFS using webhdfs

poojan 388 views 0 comments 1 point Started by poojan June 2021
Vertica Machine Images for AWS and GCP

Bryan_H 343 views 0 comments 0 points Started by Bryan_H June 2021
Storing source file names when loading data

Question Bryan_H 422 views 0 comments 0 points Started by Bryan_H May 2021
REGR_SLOPE PRECISION

SruthiA 454 views 0 comments 1 point Started by SruthiA April 2021
Using admintools to List Nodes for a Particular Database

Jim_Knicely 1.6K views 1 comment 0 points Most recent by Anonymous_Wombat March 2021
Split a string into parts

[Deleted User] 6K views 2 comments 1 point Most recent by marcothesane November 2020
Have VSQL Beep Upon Command Completion

Jim_Knicely 1.9K views 2 comments 1 point Most recent by carl125 November 2020
recovery failing after power outage

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

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

Amaksh 910 views 0 comments 0 points Started by Amaksh September 2020
Database Storage - Raw and Compressed Size

Jim_Knicely 1.8K views 1 comment 1 point Most recent by yalin September 2020
How to Create a Database with Desired Node Names

Amaksh 1K views 0 comments 0 points Started by Amaksh August 2020
Enable \timing from the vsql Command Line

[Deleted User] 2.8K views 4 comments 0 points Most recent by Jim_Knicely August 2020
How to know what is killing Vertica process

Amaksh 2.7K views 2 comments 4 points Most recent by Hibiki July 2020
How to delete the oldest partition?

Answered mosheg 1.2K views 1 comment 1 point Most recent by sahil_kumar May 2020
Replacing the Host With New IP Address

Amaksh 1.1K views 0 comments -1 point Started by Amaksh May 2020
Rebuilding the Host With the Same IP Address

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

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

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

Jim_Knicely 906 views 0 comments 1 point Started by Jim_Knicely January 2020
Loading ZIP code boundaries from a shapefile in three easy steps!

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

SergeB 1.6K views 0 comments 1 point Started by SergeB January 2020
Viewing Parquet Export Events More Easily

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

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

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

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

Jim_Knicely 974 views 1 comment 1 point Most recent by Jim_Knicely November 2019
Query spends more time on before plan

Answered VigneshN 1.9K views 3 comments 0 points Most recent by emoreno November 2019

Tips from the Team

Discussion List