Skip to Content
0
Former Member
Jul 01, 2014 at 02:12 AM

Failed to import CVS in HANA

36 Views

I attempted to import a txt file into a table, which contains BLOB type fields, but it failed. Although the import statement ran successfully, the table was empty. The SQL statement is like below:

create table TEST

(ID int primary key,

content blob);

IMPORT FROM CVS FILE '/home/XM/TEST.txt' INTO "XM_CN".TEST

WITH THREADS 10 RECORD DELIMITED BY '\n' FIELD DELIMITED BY '\t';

The content of the txt file is:

ID CONTENT 1 something

If I replace the "something" with "1010", the table will be filled.

And using insert statement to insert record is also OK:

insert into TEST values(2, 'another thing')

Can someone help advice this issue?

Thanks,

Min Xu