Tips from the Team

Announcements, news, and tips from Vertica employees.

How to convert numeric value stored in histogram data to timestamp

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

Announcement mosheg 1.1K 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 754 views 1 comment -5 points Most recent by SruthiA March 15
SQL Reserved Words

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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