Uploaded image for project: 'Sqoop'
  1. Sqoop
  2. SQOOP-3235

Sqoop SAP ECC Sybase database error

    XMLWordPrintableJSON

    Details

    • Type: Improvement
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 1.4.4
    • Fix Version/s: None
    • Component/s: tools
    • Labels:
      None

      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

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              sumitsrjhs Sumit Shrivastava
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated: