Sqoop
  1. Sqoop
  2. SQOOP-414

Column names are not guaranteed in order for getColumnNames of OracleManager

    Details

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

      Description

      OracleManager uses the following query to retrieve column names:
      public static final String QUERY_COLUMNS_FOR_TABLE =
      "SELECT COLUMN_NAME FROM ALL_TAB_COLUMNS WHERE "
      + "OWNER = ? AND TABLE_NAME = ?";

      However, it does not guarantee the order of the returned column names
      unless a "ORDER BY" is specified. This may not work properly for newer
      version of Oracle.

      1. SQOOP-414.patch
        0.6 kB
        Bilung Lee

        Activity

        Bilung Lee created issue -
        Bilung Lee made changes -
        Field Original Value New Value
        Attachment SQOOP-414.patch [ 12507969 ]
        Hide
        Arvind Prabhakar added a comment -

        Changes look good Bilung.

        Show
        Arvind Prabhakar added a comment - Changes look good Bilung.
        Hide
        Arvind Prabhakar added a comment -

        Patch committed. Thanks Bilung!

        Show
        Arvind Prabhakar added a comment - Patch committed. Thanks Bilung!
        Arvind Prabhakar made changes -
        Status Open [ 1 ] Patch Available [ 10002 ]
        Assignee Bilung Lee [ bleeapache ]
        Fix Version/s 1.4.1-incubating [ 12318902 ]
        Hide
        Hudson added a comment -

        Integrated in Sqoop-ant-jdk-1.6 #69 (See https://builds.apache.org/job/Sqoop-ant-jdk-1.6/69/)
        SQOOP-414. Column name ordering guarantee for OracleManager.

        (Bilung Lee via Arvind Prabhakar)

        arvind : http://svn.apache.org/viewvc/?view=rev&rev=1220973
        Files :

        • /incubator/sqoop/trunk/src/java/org/apache/sqoop/manager/OracleManager.java
        Show
        Hudson added a comment - Integrated in Sqoop-ant-jdk-1.6 #69 (See https://builds.apache.org/job/Sqoop-ant-jdk-1.6/69/ ) SQOOP-414 . Column name ordering guarantee for OracleManager. (Bilung Lee via Arvind Prabhakar) arvind : http://svn.apache.org/viewvc/?view=rev&rev=1220973 Files : /incubator/sqoop/trunk/src/java/org/apache/sqoop/manager/OracleManager.java
        Hide
        Jarek Jarcec Cecho added a comment -

        Patch for this issue is already committed, so I'm closing this JIRA.

        Show
        Jarek Jarcec Cecho added a comment - Patch for this issue is already committed, so I'm closing this JIRA.
        Jarek Jarcec Cecho made changes -
        Status Patch Available [ 10002 ] Resolved [ 5 ]
        Resolution Fixed [ 1 ]
        Transition Time In Source Status Execution Times Last Executer Last Execution Date
        Open Open Patch Available Patch Available
        2h 31m 1 Arvind Prabhakar 19/Dec/11 22:13
        Patch Available Patch Available Resolved Resolved
        19d 18h 33m 1 Jarek Jarcec Cecho 08/Jan/12 16:47

          People

          • Assignee:
            Bilung Lee
            Reporter:
            Bilung Lee
          • Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development