Uploaded image for project: 'Sqoop (Retired)'
  1. Sqoop (Retired)
  2. SQOOP-3155

Select oracle Database

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Resolved
    • Minor
    • Resolution: Won't Fix
    • 1.4.6
    • None
    • connectors
    • None

    Description

      Hi Guys,

      So I was trying to import some data from a oracle database and after getting a lot of errors this is my connection string:

      sqoop import -connect "jdbc:oracle:thin:@(description=(address=(protocol=tcp)(host=xxxxx)(port=6778))(connect_data=(service_name=xxxx)))" -m 1 --username test1-password supersafe --table SID.TABLE_NAME --hive-import --hive-overwrite --hive-database test1

      The export works without any Problem. When sqoop tries to create a table
      it say that it cannot create a table with SID.TABLE_NAME unter the database test1. I think it would be nice that the sqoop import --table ignores everything before "." on the parameter.

      Error: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. Invalid table name test1.SID.TABLE_NAME

      Attachments

        Activity

          People

            Unassigned Unassigned
            jomach Jorge Machado
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: