I am having problems loading data from the following website:
http://gdelt.utdallas.edu/data/backfiles/?O=D
I was successful in creating the tables that I needed to and downloading the files from that website. However, when I tried running a load script I created, I didn't get any errors - but Vertica returned that 0 rows were loaded. The following is the script I ran for one of the files:
copy GDELT_HISTORICAL from ‘/opt/vertica/gdelt_files/1979.csv’ RECORD TERMINATOR E‘/n’;
When unzipped, the files from the website I gave is a .csv file. Any ideas on what I can do to successfully load this data into my Vertica db?
Thanks ahead of time!
loading data from website
Moderator: NorbertKrupa
Re: loading data from website
Hi!
[DELETED]
[DELETED]
Last edited by id10t on Sat May 09, 2015 3:14 pm, edited 1 time in total.
Re: loading data from website
Figured it out - if anyone else has a problem similar to mine look for the log files in the CopyErrorLogs directory:
# find / -name 'CopyErrorLogs'
# find / -name 'CopyErrorLogs'