Hi All, We are trying to read LONG VAR CHAR data which has named value pair separated by '+' and the columns itself are delimited by semicolon. For example the column has data like this: Sequence+19;Description+SB;OrderStatus+Created If we pass attribute name as Sequence, then it should return: 19 I...

All,

If I receive a file with header and trailer, how can I exclude them while loading using copy command. For ex: below is the file format
Is it possible to exclude C1 and C2 from loading in to the table?

Thanks so much sKwa. This is great idea. But is it possible to not include c1 c2 and c3 as part of copy command but still achieve this?

Hi All, We have resolved this. In Vertica, only a super user (or sudo) can copy the data. See the following from manual: Only a superuser can use the COPY statement to bulk load data. The COPY exceptions to requiring a superuser to bulk load data files are to run copy to load from a stream on the ho...

sKwa, knicely87, Assume if a file used for bulk loading has 20 million records with 7 columns, then I would like to add 3 additional static auditing columns to all the 20 million records while loading using copy command. Is it possible to include these columns with copy command (Ofcourse table has 7...

Jim,

I too have the same question like becky. Additionally what will be the storage location for a user? How can we know that?

Knicely, I too faced the same error and I modified to use stdin/copy command. But I still faced the same error. However, when I removed exceptions from the command it worked just fine. See below. This worked: cat /home/xxxxxx/file.dat | /opt/vertica/bin/vsql -U xxxxxx-w yyyyyy -c "copy xxxxxx.book f...