Tips from the Team

Discussion List

• 
  Allowing Users to Query a View Owned by Another User

  Jim_Knicely 2.5K views 0 comments 0 points Most recent by Jim_Knicely January 2019
• 
  Keep Data Collector Information for a Set Interval

  Jim_Knicely 5.9K views 3 comments 1 point Most recent by chaima January 2019
• 
  A View Owner Needs Access to the Underlying Objects

  Jim_Knicely 2.6K views 0 comments 0 points Most recent by Jim_Knicely January 2019
• 
  List Table Rows by ROS Container

  Jim_Knicely 4.7K views 2 comments 0 points Most recent by Jim_Knicely January 2019
• 
  Preserving Objects Owned by a Dropped User

  Jim_Knicely 2K views 0 comments 0 points Most recent by Jim_Knicely January 2019
• 
  Tracking Save Points

  Jim_Knicely 2K views 0 comments 0 points Most recent by Jim_Knicely January 2019
• 
  Turn Off Row Counts in VSQL

  Jim_Knicely 2.2K views 0 comments 0 points Most recent by Jim_Knicely December 2018
• 
  Generate a Notice Not an Error When Adding a Duplicate Column to a Table

  Jim_Knicely 2.2K views 0 comments 0 points Most recent by Jim_Knicely December 2018
• 
  Swapping Schemas

  Jim_Knicely 2.1K views 0 comments 0 points Most recent by Jim_Knicely December 2018
• 
  Confirming if a Data Load was Apportioned

  Jim_Knicely 2K views 0 comments 0 points Most recent by Jim_Knicely December 2018
• 
  Sort Data from Within a View

  Jim_Knicely 4.5K views 2 comments 0 points Most recent by Jim_Knicely December 2018
• 
  Copy Table History

  Jim_Knicely 2.1K views 0 comments 0 points Most recent by Jim_Knicely December 2018
• 
  Handling Expression Errors in COPY Statements

  Jim_Knicely 2.3K views 0 comments 0 points Most recent by Jim_Knicely December 2018
• 
  Encode Projection Columns with Zstandard Compression

  Jim_Knicely 2.1K views 0 comments 0 points Most recent by Jim_Knicely December 2018
• 
  Display Tables Referenced by a View

  Jim_Knicely 2.3K views 0 comments 0 points Most recent by Jim_Knicely November 2018
• 
  Calculate the Catalog Size in Memory on Each Node

  Jim_Knicely 2.3K views 0 comments 1 point Most recent by Jim_Knicely November 2018
• 
  Labeling Queries

  Jim_Knicely 2.2K views 0 comments 0 points Most recent by Jim_Knicely November 2018
• 
  Create a User Defined SQL Function to Calculate Fibonacci Numbers

  Jim_Knicely 2.1K views 0 comments 0 points Most recent by Jim_Knicely November 2018
• 
  Replacing an Empty String

  [Deleted User] 14.7K views 7 comments 0 points Most recent by Jim_Knicely November 2018
• 
  Calculate Future Thanksgiving Dates

  Jim_Knicely 2K views 0 comments 0 points Most recent by Jim_Knicely November 2018
• 
  Insert Spaces Into a Character String

  Jim_Knicely 2.2K views 0 comments 0 points Most recent by Jim_Knicely November 2018
• 
  Find the Version of Vertica that Created a Database

  Jim_Knicely 2K views 0 comments 1 point Most recent by Jim_Knicely November 2018
• 
  Show all the columns in a projection's ORDER by clause

  Vertica_Curtis 3.3K views 1 comment 0 points Most recent by Jim_Knicely November 2018
• 
  Rejected Data Table Row Number

  Jim_Knicely 2.1K views 0 comments 0 points Most recent by Jim_Knicely November 2018
• 
  Reload Data from a Rejected Data Table

  Jim_Knicely 2.1K views 0 comments 0 points Most recent by Jim_Knicely November 2018
• 
  Handling Cast Conversion Load Errors

  Jim_Knicely 2.1K views 0 comments 1 point Most recent by Jim_Knicely November 2018
• 
  Calculate Request Queue Length

  Jim_Knicely 12.5K views 8 comments 1 point Most recent by chaima November 2018
• 
  Return All Cast Failures as NULL

  Jim_Knicely 2.6K views 0 comments 0 points Most recent by Jim_Knicely November 2018
• 
  Display Canceled Queries

  Jim_Knicely 2.1K views 0 comments 0 points Most recent by Jim_Knicely November 2018
• 
  Concatenate non-NULL Values from a Group

  Jim_Knicely 3.8K views 1 comment 0 points Most recent by Jim_Knicely November 2018