Welcome to the Vertica Forum

The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.

Tips from the Team

Announcements, news, and tips from Vertica employees.

Simulate NULLS FIRST and NULLS LAST in the ORDER BY Clause

Jim_Knicely 353 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 330 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 444 views 0 comments 0 points Started by Jim_Knicely March 2019
Tracking the Current Transaction Start Date and Time

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

Jim_Knicely 275 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 370 views 1 comment 1 point Most recent by qinchaofeng March 2019
Arithmetic Bit-shifting

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

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

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

Jim_Knicely 380 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 318 views 0 comments 0 points Started by Jim_Knicely March 2019
Revoke Access From Just One System Table

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

Jim_Knicely 302 views 0 comments 0 points Started by Jim_Knicely February 2019
Take a Peek at the Next Mergeout Job

Jim_Knicely 346 views 0 comments 0 points Started by Jim_Knicely February 2019
Generate a Murmur Hash

Jim_Knicely 347 views 0 comments 0 points Started by Jim_Knicely February 2019
View Tuple Mover Operation Run-time Intervals

Jim_Knicely 372 views 0 comments 0 points Started by Jim_Knicely February 2019
Auditing Flex Tables

Jim_Knicely 305 views 0 comments 0 points Started by Jim_Knicely February 2019
Tracking Table Row Counts Over Time

Jim_Knicely 401 views 0 comments 0 points Started by Jim_Knicely February 2019
Auditing Database DDL Operations

Jim_Knicely 342 views 0 comments 1 point Started by Jim_Knicely February 2019
What’s the Distance Between Two Zip Codes?

Jim_Knicely 453 views 2 comments 1 point Most recent by Jim_Knicely February 2019
Reset the ROUNDROBIN Load Balancing Counter

Jim_Knicely 316 views 0 comments 0 points Started by Jim_Knicely February 2019
Random Host Load Balancing

Jim_Knicely 316 views 0 comments 0 points Started by Jim_Knicely February 2019
Yet Another Way to De-Duplicate Table Rows

Jim_Knicely 341 views 1 comment 1 point Most recent by mkheir February 2019
Combining Functions to Extract Discrete Data From a String

Jim_Knicely 321 views 0 comments 0 points Started by Jim_Knicely February 2019
Calculate a Year’s Chinese Zodiac Animal

Jim_Knicely 306 views 0 comments 0 points Started by Jim_Knicely February 2019
Finding All Columns Storing Some Value

Jim_Knicely 565 views 0 comments 0 points Started by Jim_Knicely February 2019
Viewing External Table Definitions

Jim_Knicely 315 views 0 comments 0 points Started by Jim_Knicely February 2019
Generate a Random Integer Within a Range

Jim_Knicely 345 views 0 comments 0 points Started by Jim_Knicely January 2019
Seeding a Random Integer

Jim_Knicely 321 views 0 comments 0 points Started by Jim_Knicely January 2019
Seeding a Random Number

Jim_Knicely 337 views 0 comments 0 points Started by Jim_Knicely January 2019