SQL batch upload

[Tolulope_O]

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

[Former Member]

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.