sqoop-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Sumit Shrivastava (JIRA)" <j...@apache.org>
Subject [jira] [Created] (SQOOP-3235) Sqoop SAP ECC Sybase database error
Date Wed, 06 Sep 2017 11:49:00 GMT
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)

Mime
View raw message