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)