Tips from the Team

Discussion List

• 
  Extract Time from a Date

  [Deleted User] 5.6K views 2 comments 1 point Most recent by Jim_Knicely April 2018
• 
  Case-Insensitive Session Queries

  [Deleted User] 4.3K views 1 comment 0 points Most recent by Jim_Knicely March 2018
• 
  Parsing a String as Rows

  [Deleted User] 4.1K views 1 comment 0 points Most recent by KWillets March 2018
• 
  Expiring User's Password

  [Deleted User] 5.7K views 2 comments 0 points Most recent by Jim_Knicely February 2018
• 
  Superfast Table Copy

  [Deleted User] 8.8K views 4 comments 1 point Most recent by Jim_Knicely February 2018
• 
  Set a Client Connection Label

  [Deleted User] 3.9K views 1 comment 1 point Most recent by sKwa February 2018
• 
  .vsqlrc on Windows?

  marcothesane 3.9K views 1 comment 0 points Most recent by Jim_Knicely January 2018
• 
  Loading Genome data from sequencing system, illumine HiSeq Xs&2500.

  Kaito 4K views 1 comment 0 points Most recent by Moshe September 2017
• 
  Automatically Close an Idle Vertica Session

  [Deleted User] 3.2K views 0 comments 1 point Most recent by [Deleted User] March 2018
• 
  Keeping Track of Data Load Sources

  [Deleted User] 2.2K views 0 comments 0 points Most recent by [Deleted User] March 2018
• 
  View an EXPLAIN Plan in JSON Format

  [Deleted User] 2.3K views 0 comments 1 point Most recent by [Deleted User] March 2018
• 
  Moved: Vertica /python

  Closed [Deleted User] 1 view 0 comments 0 points Most recent by [Deleted User] March 2018
• 
  On-the-Fly Date Dimension

  [Deleted User] 2.5K views 0 comments 0 points Most recent by [Deleted User] March 2018
• 
  My SQL History

  [Deleted User] 2.7K views 0 comments 0 points Most recent by [Deleted User] March 2018
• 
  Getting a Word Count

  [Deleted User] 2.5K views 0 comments 0 points Most recent by [Deleted User] March 2018
• 
  Repeating

  [Deleted User] 2.3K views 0 comments 0 points Most recent by [Deleted User] March 2018
• 
  Splitting a String into Rows

  [Deleted User] 4.9K views 0 comments 0 points Most recent by [Deleted User] March 2018
• 
  Getting Every nth Row from a Table

  [Deleted User] 2.3K views 0 comments 1 point Most recent by [Deleted User] March 2018
• 
  What’s the Distance Between Two Points?

  [Deleted User] 2.4K views 0 comments 0 points Most recent by [Deleted User] March 2018
• 
  What's the current status of your Vertica cluster?

  [Deleted User] 2.3K views 0 comments 0 points Most recent by [Deleted User] March 2018
• 
  What’s the Maximum Column Size?

  [Deleted User] 2.5K views 0 comments 0 points Most recent by [Deleted User] April 2018
• 
  Summary of Cluster State

  [Deleted User] 2.3K views 0 comments 0 points Most recent by [Deleted User] April 2018
• 
  Simulating DML Operations on External Tables

  [Deleted User] 2.7K views 0 comments 0 points Most recent by [Deleted User] April 2018
• 
  How old am I?

  [Deleted User] 2.4K views 0 comments 0 points Most recent by [Deleted User] April 2018
• 
  Extract Just Numbers from a String of Characters

  [Deleted User] 3K views 0 comments 1 point Most recent by [Deleted User] April 2018
• 
  Converting Intervals to Numerics

  [Deleted User] 2.4K views 0 comments 1 point Most recent by [Deleted User] April 2018
• 
  Add Days to a Date, excluding SAT and SUN

  [Deleted User] 2.5K views 0 comments 0 points Most recent by [Deleted User] April 2018
• 
  Using a Preferred Editor in VSQL

  [Deleted User] 2.3K views 0 comments 1 point Most recent by [Deleted User] April 2018
• 
  Getting the Root of a Number

  [Deleted User] 2.2K views 0 comments 0 points Most recent by [Deleted User] April 2018
• 
  Check if a Date Range Overlaps another Date Range

  [Deleted User] 2.3K views 0 comments 1 point Most recent by [Deleted User] April 2018