@shashank_p - Can you run the following SQL commands and provide the output so that we can see the data types in the table: SELECT table_schema, table_name, column_name, data_type, data_type_length F… (View Post)

Why not take advantage of Apportioned Load? https://www.vertica.com/blog/faster-data-loads-with-apportioned-load-quick-tip/ (View Post)

The DDL in your attached file is not Vertica DDL :) For example, it's referenceing a data type "numerivalue". (View Post)

REGEXP_LIKE works fine on LONG data types like LONG VARCHAR. Example: dbadmin=> CREATE TABLE t (c LONG VARCHAR);CREATE TABLEdbadmin=> INSERT INTO t SELECT 'Some junk'; OUTPUT-------- … (View Post)

Like this: dbadmin=> INSERT INTO t SELECT E'\xa0' || 'Test!' || E'\xa0'; OUTPUT-------- 1(1 row)dbadmin=> SELECT * FROM t; c----------- Some junk ▒Test!▒(2 rows)db… (View Post)