loading data from website

[sdorich]

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!

[id10t]

Hi!

[DELETED]

[sdorich]

Figured it out - if anyone else has a problem similar to mine look for the log files in the CopyErrorLogs directory:

# find / -name 'CopyErrorLogs'