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
Search found 3 matches
- Mon Aug 04, 2014 4:56 pm
- Forum: New to Vertica SQL
- Topic: Using Wild Card with COPY LOCAL
- Replies: 3
- Views: 7422
- 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...
- 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...