Skip to Content

SQL batch upload

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
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

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

    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.

    Add comment
    10|10000 characters needed characters exceeded