Thanks for the reply , If possible can you recommand me any book or website that i can learn more about it .As you can see my data that i want to load into vertica is mixture of varchar and integer and this is very important for me .



Thanks in advance

May i ask what the meaning of this following commands ? "COPY test ( fa FILLER VARCHAR(512), fb FILLER VARCHAR(512), a AS TRIM(BOTH '"' FROM fa), b AS TRIM(BOTH '"' FROM fb)) FROM '/usr/home/dbadmin/test1.txt' DELIMITER ',' ESCAPE AS E'\001' RECORD TERMINATOR E'"\n';" Thanks in advance for any answe...

Hi May i know how to create csv file and load the data in vertica ? Below is the data that i want to put in the csv file ,Thanks you "Cat A Jan 2013 1st Rd :S$92100 Cat A Jan 2013 2nd Rd :S$91010 Cat A Feb 2013 1st Rd :S$87109 Cat A Feb 2013 2nd Rd :S$78301 Cat A Mar 2013 1st Rd :S$74689 Cat A Mar 2...

Hi Jimey i did follow your advice ,but why i can't create a txt file using \! ? Below is the command that i had try .Thank you VMart_Schema=> \i pwd pwd: No such file or directory VMart_Schema=> \! pwd /opt/vertica/examples/VMart_Schema VMart_Schema=> \! cat test1.txt cat: test1.txt: No such file or...

Why they throwing me the error this error
"VMart_Schema=> \! cat test1.txt
cat: test1.txt: No such file or directory "
Thanks for advance

I try this command to go cd that you told me just wondering it this command is correct ?Below is the command that i try VMart_schema=> \set t_VMart_Schema 'VMart_Schema' VMart_schema=> \set input_file '''':t_VMart_Schema'/Date Dimension.tbl''' VMart_schema=> COPY Date_Dimension FROM :input_file DELI...

How can i load data with insert command ? Any example steps to have a look ?