Welcome to the Vertica Forum

Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

Tips from the Team

Announcements, news, and tips from Vertica employees.

Displaying the Vertica Code Name

Jim_Knicely 711 views 0 comments 0 points Started by Jim_Knicely April 2019
Forcing a Merge Join

Jim_Knicely 1.4K views 0 comments 1 point Started by Jim_Knicely April 2019
Descending Sequences

Jim_Knicely 701 views 0 comments 0 points Started by Jim_Knicely April 2019
Display Session Sequence Cached Values Remaining

Jim_Knicely 732 views 0 comments 0 points Started by Jim_Knicely April 2019
Is this a Leap Year?

Jim_Knicely 793 views 0 comments 0 points Started by Jim_Knicely April 2019
How Old Am I (In Months)?

Jim_Knicely 825 views 0 comments 0 points Started by Jim_Knicely April 2019
Display the Vertica Process Memory Allocated

Jim_Knicely 831 views 0 comments 0 points Started by Jim_Knicely April 2019
Display Database Statement Counts by Type

Jim_Knicely 752 views 0 comments 1 point Started by Jim_Knicely April 2019
Use Time Series Analytics to Generate a List of Dates at a Specific Start Date

Jim_Knicely 1.6K views 0 comments 0 points Started by Jim_Knicely April 2019
Truncating a Timestamp

Jim_Knicely 846 views 0 comments 0 points Started by Jim_Knicely April 2019
Partition a Table By More Than One Column

Jim_Knicely 1.1K views 0 comments 0 points Started by Jim_Knicely April 2019
Accept the EULA When Installing Vertica

Jim_Knicely 861 views 0 comments 0 points Started by Jim_Knicely April 2019
Fun April Fool’s Day Trick Using Directed Queries

Jim_Knicely 771 views 0 comments 1 point Started by Jim_Knicely April 2019
Properly Identifying Identifiers

Jim_Knicely 781 views 0 comments 0 points Started by Jim_Knicely March 2019
Display a Query Title in VSQL

Jim_Knicely 781 views 0 comments 0 points Started by Jim_Knicely March 2019
Run the Same Query Over and Over Again in VSQL

Jim_Knicely 782 views 0 comments 0 points Started by Jim_Knicely March 2019
Find out When Vertica was Last Updated

Jim_Knicely 794 views 0 comments 0 points Started by Jim_Knicely March 2019
Simulate NULLS FIRST and NULLS LAST in the ORDER BY Clause

Jim_Knicely 1K views 0 comments 0 points Started by Jim_Knicely March 2019
Using sed to Handle Empty String NULL Values Enclosed in Control Characters

Jim_Knicely 1.1K views 0 comments 0 points Started by Jim_Knicely March 2019
Using COPY FILLER to Handle Empty String NULL Values Enclosed in Control Characters

Jim_Knicely 1.5K views 0 comments 0 points Started by Jim_Knicely March 2019
Tracking the Current Transaction Start Date and Time

Jim_Knicely 762 views 0 comments 0 points Started by Jim_Knicely March 2019
Simple ASCII Charting Using SQL

Jim_Knicely 753 views 0 comments 1 point Started by Jim_Knicely March 2019
Set All User’s Default Roles to All of their Granted Roles

Jim_Knicely 1K views 1 comment 1 point Most recent by qinchaofeng March 2019
Arithmetic Bit-shifting

Jim_Knicely 752 views 0 comments 0 points Started by Jim_Knicely March 2019
Convert an Integer to a Binary

Jim_Knicely 892 views 0 comments 0 points Started by Jim_Knicely March 2019
Are These Two String Values Like Each Other?

Jim_Knicely 782 views 0 comments 0 points Started by Jim_Knicely March 2019
Identify a Tables Primary Key Columns

Jim_Knicely 1.1K views 0 comments 0 points Started by Jim_Knicely March 2019
Revoke Access to Multiple System Tables from Multiple Users with a New Role

Jim_Knicely 845 views 0 comments 0 points Started by Jim_Knicely March 2019
Revoke Access From Just One System Table

Jim_Knicely 816 views 0 comments 0 points Started by Jim_Knicely February 2019
Viewing Internal Statements Executed by Vertica

Jim_Knicely 802 views 0 comments 0 points Started by Jim_Knicely February 2019