Skip to Content
1

SQL batch upload

Jul 18, 2017 at 04:53 AM

74

avatar image

good day,

I intend to upload a large set of data into an existing HANA table. below is the command that fails.

IMPORT FROM CSV FILE '/test/test.csv' INTO "yyy"."xxx" WITH RECORD DELIMITED BY '\n' FIELD DELIMITED BY ',' optionally enclosed by '"' BATCH 2000;

the error i get is below:

SAP DBTech JDBC: [439]: composite error: [#1, SQL-403] internal error

SQL
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

avatar image
Former Member Jul 21, 2017 at 11:46 AM
0

Same here:

IMPORT FROM CSV FILE '/test/test.csv' INTO "yyy"."xxx"

WITH RECORD DELIMITED BY '\n'

FIELD DELIMITED BY ','

optionally enclosed by '"'

error log 'xxx.err';

I get the exact same Error but 'xxx.err' does not exist.

Share
10 |10000 characters needed characters left characters exceeded