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

        Activity

        There are no comments yet on this issue.

          People

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

            Dates

            • Created:
              Updated:

              Development