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
Search found 33 matches
- Mon Apr 15, 2013 5:19 pm
- Forum: Vertica Data Load
- Topic: How to load a simple CSV?
- Replies: 22
- Views: 56032
- Sun Apr 14, 2013 4:54 pm
- Forum: Vertica Data Load
- Topic: How to load a simple CSV?
- Replies: 22
- Views: 56032
Re: How to load a simple CSV?
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...
- Thu Apr 11, 2013 3:24 am
- Forum: Vertica Data Load
- Topic: How to load a simple CSV?
- Replies: 22
- Views: 56032
Re: How to load a simple CSV?
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...
- Mon Apr 08, 2013 3:12 am
- Forum: Vertica Data Load
- Topic: How to load a simple CSV?
- Replies: 22
- Views: 56032
Re: How to load a simple CSV?
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...
- Fri Apr 05, 2013 9:28 am
- Forum: Vertica Data Load
- Topic: How to load a simple CSV?
- Replies: 22
- Views: 56032
Re: How to load a simple CSV?
Why they throwing me the error this error
"VMart_Schema=> \! cat test1.txt
cat: test1.txt: No such file or directory "
Thanks for advance
"VMart_Schema=> \! cat test1.txt
cat: test1.txt: No such file or directory "
Thanks for advance
- Fri Apr 05, 2013 6:13 am
- Forum: Vertica Database Administration
- Topic: CREATE SCHEMA is not working
- Replies: 12
- Views: 21901
Re: CREATE SCHEMA is not working
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...
- Fri Apr 05, 2013 4:00 am
- Forum: Vertica Performance Tuning
- Topic: Slow Inserts
- Replies: 7
- Views: 20609
Re: Slow Inserts
How can i load data with insert command ? Any example steps to have a look ?