I tend to agree - ROW_NUMBER() on the v_catalog.columns table , when, in one of the databases I work with, I end up with over 300 million total columns in the database, is a bit like chopping off a t… (View Post)

Hi Alex - If your table looks like this: CREATE TABLE merge_target ( prod_ky INT NOT NULL PRIMARY KEY, prod_price NUMERIC(18,2)); , the staging table merge_source has the same structure, and your MER… (View Post)

I would try REGEXP_REPLACE() as a function: WITH input(src) AS ( SELECT 'agricultural & manufacturing reforms'UNION ALL SELECT 'manufacturing & construction sectors')SELEC… (View Post)

I would not leave it at that, @joergschaber . To illustrate the question: An 'à' sign uses 2 bytes in a Vertica UTF-8 string. The 'a' sign uses 1 byte. The Euro sign - '€… (View Post)

Do you mean this? CREATE TABLE par ( par_id INTEGER NOT NULL, par_name VARCHAR(32), CONSTRAINT pk_par PRIMARY KEY(par_id))SEGMENTED BY HASH(par_id) ALL NODES;CREATE TABLE chi ( chi_id INTEGER NOT NUL… (View Post)