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

Sqoop metastore doesn't seem to recognize --schema option

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 1.4.7
    • Component/s: None
    • Labels:
      None

      Description

      PROBLEM:
      When running sqoop job using sqoop metastore:
      sqoop job --create 'globaldata.r.emaildomain' --meta-connect 'jdbc:hsqldb:hsql://host:16000/sqoop' --import --connect 'jdbc:sqlserver://;database=DB;user=x;password=xxx' --table Tt --target-dir /hive/globaldatastaging/emaildomain --split-by 'DomainID' --num-mappers 8 --columns 'a,b,c' --hive-drop-import-delims --fields-terminated-by '\001' --lines-terminated-by '\n' --null-string '
      N' --null-non-string '
      N' – --schema lookup
      It is throwing the error that it cannot find the table when executing the job:
      15/08/24 15:21:18 INFO manager.SqlManager: Executing SQL statement: SELECT t.* FROM Tt AS t WHERE 1=0
      15/08/24 15:21:18 ERROR manager.SqlManager: Error executing statement: com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'EmailDomain'.

        Attachments

        1. SQOOP-2779.V0.patch
          3 kB
          Sowmya Ramesh

          Issue Links

            Activity

              People

              • Assignee:
                sowmyaramesh Sowmya Ramesh
                Reporter:
                sowmyaramesh Sowmya Ramesh
              • Votes:
                0 Vote for this issue
                Watchers:
                4 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: