Tips from the Team

Discussion List

• 
  Summarize the Values in a String

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

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

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

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

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

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

  Bryan_H 1.9K views 0 comments 0 points Started by Bryan_H October 2019
• 
  Extending Vertica with Python functions: adding NumPy FFT as a UDx

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

  Bryan_H 1.8K views 0 comments -1 point Started by Bryan_H October 2019
• 
  Tracking Raw Schema Size Over Time

  Jim_Knicely 1.9K views 0 comments 1 point Started by Jim_Knicely September 2019
• 
  Easy Development Schema Cleanup (i.e. Have Vertica Drop a Bunch of Tables for You)

  Jim_Knicely 1.7K views 0 comments 1 point Started by Jim_Knicely September 2019
• 
  Investigate Data Collector Table Data Produced by a Scrutinize

  Jim_Knicely 1.8K views 0 comments -1 point Started by Jim_Knicely September 2019
• 
  Load Data Enclosed By and Embedded With Double Quotes

  Jim_Knicely 2.4K views 0 comments 0 points Started by Jim_Knicely September 2019
• 
  Make a Cow Display Query Results in VSQL

  Question Jim_Knicely 1.8K views 0 comments 1 point Most recent by Jim_Knicely August 2019
• 
  Stop a Stubborn Query that Won’t Cancel

  Answered Jim_Knicely 6.1K views 2 comments 0 points Most recent by Jim_Knicely August 2019
• 
  Change Your User Password in VSQL with a Meta-Command

  Jim_Knicely 2K views 0 comments 0 points Most recent by Jim_Knicely August 2019
• 
  View the History of Connection Load Balance Operations

  Jim_Knicely 1.8K views 0 comments 0 points Most recent by Jim_Knicely August 2019
• 
  Load Balance Older Clients (That You Can’t Upgrade for Some Weird Reason)

  Jim_Knicely 1.8K views 0 comments 0 points Most recent by Jim_Knicely August 2019
• 
  Testing the Native Load Balancer

  Jim_Knicely 1.8K views 0 comments 0 points Most recent by Jim_Knicely August 2019
• 
  Diving into disk usage

  Bryan_H 1.9K views 0 comments 0 points Most recent by Bryan_H August 2019
• 
  Find and fix issues from Vertica query events

  Bryan_H 2K views 0 comments 0 points Most recent by Bryan_H August 2019
• 
  Find the Busiest Hour in the Day for I/O

  Jim_Knicely 1.8K views 0 comments 0 points Most recent by Jim_Knicely August 2019
• 
  Theoretical Maximum Number of Rows Per Table Per Node

  Jim_Knicely 1.8K views 0 comments 0 points Most recent by Jim_Knicely August 2019
• 
  Watch those delete vectors!

  Bryan_H 6.5K views 3 comments 0 points Most recent by emoreno July 2019
• 
  Streaming data in one line!

  Bryan_H 2K views 0 comments 0 points Most recent by Bryan_H July 2019
• 
  Restore a Single Database View from a Backup

  Jim_Knicely 1.8K views 0 comments 1 point Most recent by Jim_Knicely July 2019
• 
  Avoid 1:1 Relationships in Your Data Model

  Jim_Knicely 1.8K views 0 comments 0 points Most recent by Jim_Knicely July 2019
• 
  Looking into details of locking

  Bryan_H 1.9K views 0 comments 0 points Most recent by Bryan_H July 2019