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!