Uploaded image for project: 'Sqoop (READ-ONLY)'
  1. Sqoop (READ-ONLY)
  2. SQOOP-204

Generated Input-split bounds query for free-form query import in Oracle does not work.

    Details

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

      Description

      During a free form query import on Oracle, the generated bounds query is as follows:

      SELECT MIN(BAR), MAX(BAR) FROM (SELECT * FROM FOO WHERE (1=1)) AS TABLE_NAME

      This query does not work with Oracle since it does not allow the use of AS to project a sub-query as table. Instead the correct syntax will be something like the following:

      SELECT MIN(BAR), MAX(BAR) FROM (SELECT * FROM FOO WHERE (1=1)) TABLE_NAME

        Attachments

          Activity

            People

            • Assignee:
              arvind Arvind Prabhakar
              Reporter:
              arvind Arvind Prabhakar
            • Votes:
              2 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: