SQL batch upload

Tolulope_O — Tue, 18 Jul 2017 04:53:30 GMT

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

Re: SQL batch upload

Former Member — Fri, 21 Jul 2017 11:46:08 GMT

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.