Tips from the Team

Discussion List

• 
  How to convert numeric value stored in histogram data to timestamp

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

  Announcement mosheg 1.8K views 0 comments 1 point Started by mosheg October 2019
• 
  What Version of Vertica am I Running?

  [Deleted User] 2K views 1 comment 0 points Most recent by Hibiki August 21
• 
  Partition a Table By More Than One Column

  Jim_Knicely 3.7K views 3 comments 0 points Most recent by scherepanov May 28
• 
  How to make auto start Vertica DB after reboot vertica node in vertica version 12.0

  Answered Closed navaneet 2.2K views 1 comment -5 points Most recent by SruthiA March 2023
• 
  SQL Reserved Words

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

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

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

  Question Bryan_H 1.3K views 0 comments 0 points Started by Bryan_H May 2021
• 
  REGR_SLOPE PRECISION

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

  Bryan_H 3.5K 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.8K 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.9K views 0 comments 1 point Started by Bryan_H January 2020
• 
  Base64 decode/encode functions in Vertica (via Python UDX-SDK)

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

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

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

  Bryan_H 2.2K views 0 comments 1 point Started by Bryan_H December 2019