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

Oracle Data Connector Doesn't Support Case Sensitive Table Names

    Details

    • Type: Bug
    • Status: Open
    • Priority: Minor
    • Resolution: Unresolved
    • Affects Version/s: 1.4.6
    • Fix Version/s: None
    • Component/s: connectors/oracle
    • Labels:
      None

      Description

      Currently the Oracle Data Connector uppercases table names before querying the data dictionary for columns causing it to fail when you try to import a lowercase table name. This is probably caused by OraOopUtilities upper casing the table names under decodeOracleTableName. Ideally we would just accept the case inputed or try to detect the double quotes around the table name. From the debug logs you end up with something like this. The message implies some sort of double quoting will fix the issue but I haven't discovered any combination that does.

       

      The Oracle table context has been derived from:
      oracleConnectionUserName = someuser
      tableStr = STAGE.blah_201612160955
      as:
      owner : STAGE
      table : BLAH_201612160955
      
      Data Connector for Oracle and Hadoop will not process this Sqoop connection, as the Oracle user STAGE does not own a table named BLAH_201612160955.
      Please prefix the table name with the owner.
      Note: You may need to double-quote the owner and/or table name.
      E.g. sqoop ... --username someuser --table STAGE.BLAH_201612160955

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              Absolutesantaja Shawn Weeks
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated: