Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

SQL batch upload

tolulope_okusaga
Participant

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

  • SAP Managed Tags:
1 REPLY 1

Former Member
0 Kudos

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.

  • SAP Managed Tags: