Skip to Content
0
Former Member
Apr 14, 2014 at 11:01 AM

Unable to import full CSV

477 Views

Hello,

I have a CSV File with a bit more then 320.000 Rows.

A Table which should store the Rows.

I guess enough Harddisc to load.

A HANA 1.00.68.384084

My Control file looks like this:

IMPORT DATA

INTO TABLE "KTH"."MyTable"

FROM '/cloudfolders/mycsv_utf.csv'

RECORD DELIMITED BY '\n'

FIELDS DELIMITED BY ','

OPTIONALLY ENCLOSED BY '"'

ERROR LOG '/cloudfolders/mycsv_utf_error.txt'

I call the Controlfile from HANA Studio with the following Command:

IMPORT FROM CONTROL FILE '/cloudfolders/my_control_file.ctl'

WITH

THREADS 10

BATCH 10000;

260.000 Rows are well imported.

A Error File "mycsv_utf_error.txt" get created (With wrong permissions?)

But the errorfile keeps empty (0 Byte). Also when I try to CMOD the File to 777 and re-run the Load Command.

I need to know which rows cause the error to solve the Problem (Data / Table / ...)

Any Idea?

Regards,