This blog post was authored by Jim Knicely. One of my favorite functions in Vertica is named SPLIT_PART. It splits up a string into parts by a given delimiter. Example: dbadmin=> SELECT split_part… (View Post)

Vertica 9.0.0-1 and later versions support Amazon Linux 2017.09. * To run Vertica on Amazon Linux 2017.09, you must use Vertica 9.0.0-1 or later. There are required enhancements in this hotfix for ru… (View Post)

Jim Knicely authored this tip. The easiest way to extract just the numbers from a string of characters is to simply remove any character that isn’t a number! Example: dbadmin=> SELECT c1, regexp_r… (View Post)