Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!
- Last Active
- Administrator, Moderator, Vertica Employee, Member, VerticaExpert, VerticaPartners
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 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
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