SarahL
Administrator
Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!
SarahL Administrator
Reactions
-
Split a string into parts
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)1 -
Vertica 9.0.0-1 Supports Amazon Linux 2017.09
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)1 -
Extract Just Numbers from a String of Characters
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)1