Hi Skwa/all, Have question on ignoring columns in case of a delimited file using COPY. Please help. for the same table structre in my above post, say if I have input like this : $cat input.txt myname|19900605|23|30000|mytown I want to ignore field 2 and field 5 while loading. I tried this way, COPY ...

Hi Skwa,

Thanks a lot for your quick response.

Hi All, I am loading FIXED LENGTH ASCII File using COPY command. My input file has more columns than the target tables and hence while loading I wish to ignore columns that doesnt required to be loaded. Example as below: $ cat >input.txt myname199007082330000mytown Inout fileformat as : Name(6),birt...

Dear jpcavanaugh,

I do need this module to load EBCIDIC input file. Can you please help me?

Thanks,
Ramvertica

I am using Vertica 6 in an AIX machine. I'm connecting to vertica using VSQL and I use COPY command to load data from my local directory to vertica DB. I load both FIXED LENGTH as well as DELMITED file. Fixed length : cat filename.txt | vsql -h myverticanode -u myuser -w passwd -c "set role all; cop...