[SQOOP-3235] Sqoop SAP ECC Sybase database error

• Type: Improvement
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 1.4.4
• Component/s: tools
• Assignee: Unassigned
• Reporter: Sumit Shrivastava
• Created: 06/Sep/17 11:48
• Updated: 06/Sep/17 11:48

Description

HI

I am trying to import data in hive through sqoop from SAP sybase but there are some tables in sap and names for the tables are starting from '/'. sqoop is raising errors for them. as well as if I want to exclude tables with wild cards like '/%', also not working. Please suggest.
command is
sqoop import-all-tables --verbose --connect jdbc:sybase:Tds:X.X.X.X:5000/TST --username sapsa --password xxxxxx --driver com.sybase.jdbc4.jdbc.SybDriver --warehouse-dir /user/hadoop --hive-database TST --hive-import --create-hive-table -m 1

Error is
DEBUG manager.SqlManager: Execute getColumnTypesRawQuery : SELECT t.* FROM /1BS/TEST_TABLE AS t WHERE 1=0
Using fetchSize for next query: 1000
Executing SQL statement: SELECT t.* FROM /1BS/TEST_TABLE AS t WHERE 1=0
Error executing statement: com.sybase.jdbc4.jdbc.SybSQLException: Incorrect syntax near '/'.
com.sybase.jdbc4.jdbc.SybSQLException: Incorrect syntax near '/'.

As well as if I m trying to exclude tables with wild cards are also not working.

Regards
Sumit