Created 02-26-2016 01:24 AM
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
Created 02-26-2016 01:28 AM
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
Created 02-26-2016 01:28 AM
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
Created 02-26-2016 01:34 AM
@Shishir Saxena Nice! You can accept the answer as your answered it already