Skip to Content
0
Nov 09, 2012 at 08:19 AM

Importing flat csv files

92 Views

I already imported some csv files from the SFLIGHT project to a TIP sandbox system, all of these imported files were quite small. I am facing some issues with the file "SBook", which contains about 1.3 million entries. Up to now I was not able to import this file correctly via HANA Studio import, although the table definitions are exactly identical with the table description.

Now I tried to import this table via SQL statement (also with HANA Studio).

This didn't work:

import data

into table "<myschema>"."SBOOK"

from 'C:\Tmp\HANA\data.csv'

record delimited by '\n'

field delimited by ','

optionally enclosed by '"'

error log 'data.err';

And the try via clt doesn't work, too - the Studio tells me, that the file data.clt cannot be opened:

import data from 'C:\Tmp\HANA\data.clt';

Are limitations known in HANA Studio with the import of huge csv files?

Has anybody experiences with the import via SQL?

Thanks a lot!