Search found 3 matches

by kbulchan
Mon Aug 04, 2014 4:56 pm
Forum: New to Vertica SQL
Topic: Using Wild Card with COPY LOCAL
Replies: 3
Views: 7422

Re: Using Wild Card with COPY LOCAL

I tried pasting the folder on C drive and the script runs successfully!
Can you please explain how does the access from drives to Vertica works and how can it be managed?
Thanks
kbulchan
by kbulchan
Mon Aug 04, 2014 4:47 pm
Forum: New to Vertica SQL
Topic: Using Wild Card with COPY LOCAL
Replies: 3
Views: 7422

Re: Using Wild Card with COPY LOCAL

Thanks for getting back on this norbertk. I am not sure about that question as I have no clue about the permissions for vertica. I have installed the vertica client on my machine and running the script using Dbvisualiser. The strange part is that the same script works for one of my colleague absolut...
by kbulchan
Fri Aug 01, 2014 12:21 pm
Forum: New to Vertica SQL
Topic: Using Wild Card with COPY LOCAL
Replies: 3
Views: 7422

Using Wild Card with COPY LOCAL

Hello, I was trying to use COPY LOCAL to load multiple files stored in a folder using wild card as shown below:- COPY DATA_test ( COLUMN001 , COLUMN002 , COLUMN003 ) FROM LOCAL 'D:\Users\kbulchan\Documents\testdata\*.csv' DELIMITER ',' ENCLOSED BY '"' DIRECT EXCEPTIONS 'D:\Users\kbulchan\Documents\L...

Go to advanced search