- Subscribe to RSS Feed
- Mark Question as New
- Mark Question as Read
- Float this Question for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Sqoop connection to SAP HANA giving SQLException in nextKeyValue
- Labels:
-
Apache Sqoop
Created ‎02-26-2016 01:24 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@Shishir Saxena Nice! You can accept the answer as your answered it already
