question Re: Sqoop connection to SAP HANA giving SQLException in nextKeyValue in Archives of Support Questions (Read Only)

Sqoop connection to SAP HANA giving SQLException in nextKeyValue

shishir_saxena4 — Fri, 26 Feb 2016 09:24:40 GMT

Sqoop to fetch data from SAP HANA is giving following error.

Error: java.io.IOException: SQLException in nextKeyValue
        at org.apache.sqoop.mapreduce.db.DBRecordReader.nextKeyValue(DBRecordReader.java:277)

Here is my sqoop statement

sqoop import --connect "jdbc:sap://<server>:30015" --driver "com.sap.db.jdbc.Driver" --username admin --password **** --table ABC.TABLE1 -m 1

Re: Sqoop connection to SAP HANA giving SQLException in nextKeyValue

shishir_saxena4 — Fri, 26 Feb 2016 09:28:17 GMT

SAP HANA driver doesn't accept Schema name in table parameter. Need to pass schemaname as part of connection parameter.

sqoop import --connect "jdbc:sap://<server>:30015/?currentschema=ABC"--driver "com.sap.db.jdbc.Driver"--username admin --password ****--table TABLE1 -m 1

Re: Sqoop connection to SAP HANA giving SQLException in nextKeyValue

nsabharwal — Fri, 26 Feb 2016 09:34:24 GMT

@Shishir Saxena Nice! You can accept the answer as your answered it already