Tips from the Team

Discussion List

• 
  User-Defined Functions to the Rescue

  [Deleted User] 8.9K views 5 comments 0 points Most recent by Jim_Knicely July 2019
• 
  Analyzing JSON Already Loaded into Vertica Regular Tables

  Bryan_H 2.1K views 0 comments 0 points Most recent by Bryan_H July 2019
• 
  Hash Function Result Depends on Data Type and Sometimes Size

  Jim_Knicely 2K views 0 comments 1 point Most recent by Jim_Knicely July 2019
• 
  Loading Data Stored in Scientific Notation to an Integer Column

  Jim_Knicely 2.1K views 0 comments 0 points Most recent by Jim_Knicely July 2019
• 
  Auto-Projection Column Sort Order

  Jim_Knicely 1.8K views 0 comments 0 points Most recent by Jim_Knicely July 2019
• 
  Coin Flip User Defined SQL Function

  Jim_Knicely 1.7K views 1 comment 0 points Most recent by Jim_Knicely July 2019
• 
  Non-DBADMIN Access to System Tables (Table by Table)

  Jim_Knicely 1.9K views 0 comments 0 points Most recent by Jim_Knicely July 2019
• 
  Tracking VBR Invocations

  Jim_Knicely 1.8K views 0 comments 0 points Most recent by Jim_Knicely June 2019
• 
  Track License Usage Over Time

  Jim_Knicely 1.8K views 0 comments 0 points Most recent by Jim_Knicely June 2019
• 
  Improving the performance of rebalancing

  [Deleted User] 4.6K views 2 comments 0 points Most recent by Ravi June 2019
• 
  Enable All Granted Roles on Login

  Jim_Knicely 1.9K views 0 comments 0 points Most recent by Jim_Knicely June 2019
• 
  Keeping Track of Data Exports and Imports

  Jim_Knicely 1.8K views 0 comments 0 points Most recent by Jim_Knicely June 2019
• 
  Eon Mode Now Available in Vertica 9.1

  [Deleted User] 8.3K views 5 comments 1 point Most recent by Jim_Knicely June 2019
• 
  Generate DDL for Changed Configuration Parameters

  Jim_Knicely 1.9K views 0 comments 0 points Most recent by Jim_Knicely June 2019
• 
  Generating Recursive COPY Commands

  Jim_Knicely 1.9K views 0 comments 0 points Most recent by Jim_Knicely June 2019
• 
  Total Table Row Count Report by Schema

  Jim_Knicely 3.1K views 0 comments 0 points Most recent by Jim_Knicely June 2019
• 
  Set the Spread Daemon Timeout Back to the Default Value

  Jim_Knicely 1.9K views 0 comments 0 points Most recent by Jim_Knicely May 2019
• 
  Monitor the Current Value of Node Spread Daemon Timeouts

  Jim_Knicely 1.9K views 0 comments 0 points Most recent by Jim_Knicely May 2019
• 
  Min and Max Values for Spread Daemon Timeout

  Jim_Knicely 1.9K views 0 comments 0 points Most recent by Jim_Knicely May 2019
• 
  Adjusting Spread Daemon Timeouts

  Jim_Knicely 1.9K views 0 comments 0 points Most recent by Jim_Knicely May 2019
• 
  Include the ALTER and DROP privileges in a GRANT ALL Statement

  Jim_Knicely 2.6K views 0 comments 0 points Most recent by Jim_Knicely May 2019
• 
  Watch Out for Data Induced “Cross” Joins

  Jim_Knicely 2K views 0 comments 0 points Most recent by Jim_Knicely May 2019
• 
  Direct Output to /dev/null in VSQL

  Jim_Knicely 1.9K views 0 comments 0 points Most recent by Jim_Knicely May 2019
• 
  NULL Values do not Count Against Your Vertica License!

  Jim_Knicely 1.8K views 0 comments 0 points Most recent by Jim_Knicely May 2019
• 
  Add a Column to All of a Table’s Projections

  Jim_Knicely 2.7K views 0 comments 0 points Most recent by Jim_Knicely May 2019
• 
  View the Query Plan for a COPY Statement

  Jim_Knicely 1.9K views 0 comments 0 points Most recent by Jim_Knicely May 2019
• 
  Close All Sessions for a User with a Single Command

  Jim_Knicely 2.4K views 0 comments 0 points Most recent by Jim_Knicely May 2019
• 
  Reading GZIP files from S3 into Vertica

  [Deleted User] 16K views 10 comments 0 points Most recent by Jim_Knicely May 2019
• 
  Table Schemas for Global and Local Temp Tables

  Jim_Knicely 2.7K views 0 comments 0 points Most recent by Jim_Knicely May 2019
• 
  Make Comparisons on Subqueries that Return Multiple Rows

  Jim_Knicely 1.9K views 0 comments 0 points Most recent by Jim_Knicely May 2019