sqoophana

Using Sqoop1 with SAP HANA using a table name that contains forward slash '/' causes error

Trying to import data from SAP HANA using table that contains a forward slash '/'. Not sure if escaping the '/' will work.

My connection attempt:

sqoop import –connect jdbc:sap://mysaphost:30015 --driver com.sap.db.jdbc.Driver --username xxxxxx --password xxxx --table xxx./xxx/xxx

Produces the following error:

2016-05-20 13:12:23,098 ERROR - [main:] ~ Error executing statement: com.sap.db.jdbc.exceptions.JDBCDriverException: SAP DBTech JDBC: [257]: sql syntax error: incorrect syntax near "/": line 1 col 24 (at pos 24) (SqlManager:43)

com.sap.db.jdbc.exceptions.JDBCDriverException: SAP DBTech JDBC: [257]: sql syntax error: incorrect syntax near "/": line 1 col 24 (at pos 24)

Solution

  • Updated to latest version of JDBC driver for SAP Hana.