Hi Raj!

Does it helps Loading UTF-8 Format Data?

Hi Raj! What is a condition of rows numbering? Enumerating - it is kind of ordering. Does table has some order? Well defined problem is a half solution. If order is by insertion time - create timestamp column and enumerate by this column. [ example ] If order is by ORDER BY aColumn/s - create projec...

Hi, Raj! What do you want? Enumerate on output? Look for function row_number() . Enumerate by insertion , so create timestamp column and... look fo row_number() over () . Table CREATE TABLE public.enumerate ( id timestamp NOT NULL, column1 varchar(80), column2 varchar(80) ); ALTER TABLE public.enume...

Hi, Jim.

I'm afraid is not the end .
You didn't investigate a case with prejoin-projections Its a long story and bad idea (imho) modify column data type on production system (there are may be segments, buddy/prejoin-projections).

Hi Billy

viewtopic.php?f=48&t=145&p=321&hilit=INTERPOLATE#p321

Hi, Beck.

If each Monday you need to change data type for some column so try to define data type "wide" as much it possible, i.e. instead INTEGER or FLOAT define NUMERIC type or VARCHAR, while in queries do casing. IMHO its a better solution than modifying column data type.

Example: [*] Create data for example : test_db=> \! mkdir -p /tmp/vertica test_db=> \! echo -e "one\ntwo\nthree" > /tmp/vertica/data_01.txt test_db=> \! echo -e "one\ntwo\nthree" > /tmp/vertica/data_02.txt test_db=> \! echo -e "one\ntwo\nthree" > /tmp/vertica/data_03.txt test_db=> \! echo -e "one\nt...