Sumit Shrivastava created SQOOP-3235:
----------------------------------------
Summary: Sqoop SAP ECC Sybase database error
Key: SQOOP-3235
URL: https://issues.apache.org/jira/browse/SQOOP-3235
Project: Sqoop
Issue Type: Improvement
Components: tools
Affects Versions: 1.4.4
Reporter: Sumit Shrivastava
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
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
