Version upgrade require custom UDx library upgrade, to use new UDx API. Library upgrade require "drop library cascade". To upgrade a UDx library, you do not need to drop the library first. … (View Post)

If you had a VARCHAR column, StringTokenizerDelim would do the job. You could still use it with an explicit cast to VARCHAR (and maximum length), but that will truncate your items argument; see examp… (View Post)

You could use some flexibility to transform and query your data. Let's try this with flex tables. First, let's do some setup. create schema tst;CREATE TABLE tst.tableB(id int,code_ varchar(30));CREAT… (View Post)

This is a known issue with the license auditor in 9.3.1. It was fixed in Vertica 9.3.1-4. (View Post)