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

DirectNetezzaManager fails to find tables from older Netezza system catalogs

    Details

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

      Description

      DirectNetezzaManager's checkTable method fails to find table and it will error out and returns something like:
      "<table_name> is not a valid Netezza table"
      The cause is the query to look for netezza table (QUERY_CHECK_DICTIONARY_FOR_TABLE) is case-sensitive. To query for tables in Netezza catalog this needs to be case-insensitive.
      Older netezza installs have system catalog tables stored in lowercase 'table', while more recent Netezza have 'TABLE' by default.
      Based on the feedback from Netezza admins, the query recommended to check for tables in _V_TABLES system catalog (instead of _V_OBJECTS) table.

      1. SQOOP-1209.patch
        1 kB
        Venkat Ranganathan

        Issue Links

          Activity

          Hide
          jira-bot ASF subversion and git services added a comment -

          Commit ddd454b9b67bd32c12cbd1230c02d2a20c27d917 in sqoop's branch refs/heads/trunk from Jarek Jarcec Cecho
          [ https://git-wip-us.apache.org/repos/asf?p=sqoop.git;h=ddd454b ]

          SQOOP-1209: DirectNetezzaManager fails to find tables from older Netezza system catalogs

          (Venkat Ranganathan via Jarek Jarcec Cecho)

          Show
          jira-bot ASF subversion and git services added a comment - Commit ddd454b9b67bd32c12cbd1230c02d2a20c27d917 in sqoop's branch refs/heads/trunk from Jarek Jarcec Cecho [ https://git-wip-us.apache.org/repos/asf?p=sqoop.git;h=ddd454b ] SQOOP-1209 : DirectNetezzaManager fails to find tables from older Netezza system catalogs (Venkat Ranganathan via Jarek Jarcec Cecho)
          Hide
          jarcec Jarek Jarcec Cecho added a comment -

          Thank you for the contribution Venkat Ranganathan!

          Show
          jarcec Jarek Jarcec Cecho added a comment - Thank you for the contribution Venkat Ranganathan !
          Hide
          hudson Hudson added a comment -

          SUCCESS: Integrated in Sqoop-ant-jdk-1.6-hadoop100 #846 (See https://builds.apache.org/job/Sqoop-ant-jdk-1.6-hadoop100/846/)
          SQOOP-1209: DirectNetezzaManager fails to find tables from older Netezza system catalogs (jarcec: https://git-wip-us.apache.org/repos/asf/?p=sqoop.git&a=commit&h=ddd454b9b67bd32c12cbd1230c02d2a20c27d917)

          • src/java/org/apache/sqoop/manager/DirectNetezzaManager.java
          Show
          hudson Hudson added a comment - SUCCESS: Integrated in Sqoop-ant-jdk-1.6-hadoop100 #846 (See https://builds.apache.org/job/Sqoop-ant-jdk-1.6-hadoop100/846/ ) SQOOP-1209 : DirectNetezzaManager fails to find tables from older Netezza system catalogs (jarcec: https://git-wip-us.apache.org/repos/asf/?p=sqoop.git&a=commit&h=ddd454b9b67bd32c12cbd1230c02d2a20c27d917 ) src/java/org/apache/sqoop/manager/DirectNetezzaManager.java
          Hide
          hudson Hudson added a comment -

          SUCCESS: Integrated in Sqoop-ant-jdk-1.6-hadoop200 #887 (See https://builds.apache.org/job/Sqoop-ant-jdk-1.6-hadoop200/887/)
          SQOOP-1209: DirectNetezzaManager fails to find tables from older Netezza system catalogs (jarcec: https://git-wip-us.apache.org/repos/asf/?p=sqoop.git&a=commit&h=ddd454b9b67bd32c12cbd1230c02d2a20c27d917)

          • src/java/org/apache/sqoop/manager/DirectNetezzaManager.java
          Show
          hudson Hudson added a comment - SUCCESS: Integrated in Sqoop-ant-jdk-1.6-hadoop200 #887 (See https://builds.apache.org/job/Sqoop-ant-jdk-1.6-hadoop200/887/ ) SQOOP-1209 : DirectNetezzaManager fails to find tables from older Netezza system catalogs (jarcec: https://git-wip-us.apache.org/repos/asf/?p=sqoop.git&a=commit&h=ddd454b9b67bd32c12cbd1230c02d2a20c27d917 ) src/java/org/apache/sqoop/manager/DirectNetezzaManager.java
          Hide
          hudson Hudson added a comment -

          SUCCESS: Integrated in Sqoop-ant-jdk-1.6-hadoop20 #881 (See https://builds.apache.org/job/Sqoop-ant-jdk-1.6-hadoop20/881/)
          SQOOP-1209: DirectNetezzaManager fails to find tables from older Netezza system catalogs (jarcec: https://git-wip-us.apache.org/repos/asf/?p=sqoop.git&a=commit&h=ddd454b9b67bd32c12cbd1230c02d2a20c27d917)

          • src/java/org/apache/sqoop/manager/DirectNetezzaManager.java
          Show
          hudson Hudson added a comment - SUCCESS: Integrated in Sqoop-ant-jdk-1.6-hadoop20 #881 (See https://builds.apache.org/job/Sqoop-ant-jdk-1.6-hadoop20/881/ ) SQOOP-1209 : DirectNetezzaManager fails to find tables from older Netezza system catalogs (jarcec: https://git-wip-us.apache.org/repos/asf/?p=sqoop.git&a=commit&h=ddd454b9b67bd32c12cbd1230c02d2a20c27d917 ) src/java/org/apache/sqoop/manager/DirectNetezzaManager.java
          Hide
          hudson Hudson added a comment -

          SUCCESS: Integrated in Sqoop-ant-jdk-1.6-hadoop23 #1083 (See https://builds.apache.org/job/Sqoop-ant-jdk-1.6-hadoop23/1083/)
          SQOOP-1209: DirectNetezzaManager fails to find tables from older Netezza system catalogs (jarcec: https://git-wip-us.apache.org/repos/asf/?p=sqoop.git&a=commit&h=ddd454b9b67bd32c12cbd1230c02d2a20c27d917)

          • src/java/org/apache/sqoop/manager/DirectNetezzaManager.java
          Show
          hudson Hudson added a comment - SUCCESS: Integrated in Sqoop-ant-jdk-1.6-hadoop23 #1083 (See https://builds.apache.org/job/Sqoop-ant-jdk-1.6-hadoop23/1083/ ) SQOOP-1209 : DirectNetezzaManager fails to find tables from older Netezza system catalogs (jarcec: https://git-wip-us.apache.org/repos/asf/?p=sqoop.git&a=commit&h=ddd454b9b67bd32c12cbd1230c02d2a20c27d917 ) src/java/org/apache/sqoop/manager/DirectNetezzaManager.java
          Hide
          venkatnrangan Venkat Ranganathan added a comment -

          Thanks Jarek Jarcec Cecho for reviewing and committing the patch

          Show
          venkatnrangan Venkat Ranganathan added a comment - Thanks Jarek Jarcec Cecho for reviewing and committing the patch

            People

            • Assignee:
              venkatnrangan Venkat Ranganathan
              Reporter:
              kaufman Kaufman Ng
            • Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Development