Sqoop
  1. Sqoop
  2. SQOOP-974

Sqoop2: Add staging table support to generic jdbc export job

    Details

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

      Description

      We should add staging table support to Generic JDBC connector export job with similar functionality as is exposed by Sqoop 1.

      1. StagingTableforSqoop-2.pdf
        85 kB
        Raghav Kumar Gautam
      2. sqoop-974.txt
        35 kB
        Raghav Kumar Gautam
      3. sqoop-974.3.txt
        29 kB
        Raghav Kumar Gautam

        Issue Links

          Activity

          Hide
          Raghav Kumar Gautam added a comment -

          Thanks Jarek Jarcec Cecho for review and committing.

          Show
          Raghav Kumar Gautam added a comment - Thanks Jarek Jarcec Cecho for review and committing.
          Hide
          Hudson added a comment -

          SUCCESS: Integrated in Sqoop2-hadoop100 #569 (See https://builds.apache.org/job/Sqoop2-hadoop100/569/)
          SQOOP-974: Sqoop2: Add staging table support to generic jdbc export job (jarcec: https://git-wip-us.apache.org/repos/asf?p=sqoop.git&a=commit&h=e33d6934761b66f24a7d197aacc3d40ea00f8155)

          • connector/connector-generic-jdbc/src/main/java/org/apache/sqoop/connector/jdbc/GenericJdbcExportInitializer.java
          • connector/connector-generic-jdbc/src/main/java/org/apache/sqoop/connector/jdbc/GenericJdbcConnectorError.java
          • connector/connector-generic-jdbc/src/test/java/org/apache/sqoop/connector/jdbc/GenericJdbcExecutorTest.java
          • connector/connector-generic-jdbc/src/main/java/org/apache/sqoop/connector/jdbc/GenericJdbcValidator.java
          • connector/connector-generic-jdbc/src/main/java/org/apache/sqoop/connector/jdbc/configuration/ExportTableForm.java
          • test/src/test/java/org/apache/sqoop/integration/connector/jdbc/generic/exports/TableStagedExportTest.java
          • connector/connector-generic-jdbc/src/main/java/org/apache/sqoop/connector/jdbc/GenericJdbcExportDestroyer.java
          • connector/connector-generic-jdbc/src/main/java/org/apache/sqoop/connector/jdbc/GenericJdbcExecutor.java
          • connector/connector-generic-jdbc/src/test/java/org/apache/sqoop/connector/jdbc/TestExportInitializer.java
          • connector/connector-generic-jdbc/src/main/resources/generic-jdbc-connector-resources.properties
          Show
          Hudson added a comment - SUCCESS: Integrated in Sqoop2-hadoop100 #569 (See https://builds.apache.org/job/Sqoop2-hadoop100/569/ ) SQOOP-974 : Sqoop2: Add staging table support to generic jdbc export job (jarcec: https://git-wip-us.apache.org/repos/asf?p=sqoop.git&a=commit&h=e33d6934761b66f24a7d197aacc3d40ea00f8155 ) connector/connector-generic-jdbc/src/main/java/org/apache/sqoop/connector/jdbc/GenericJdbcExportInitializer.java connector/connector-generic-jdbc/src/main/java/org/apache/sqoop/connector/jdbc/GenericJdbcConnectorError.java connector/connector-generic-jdbc/src/test/java/org/apache/sqoop/connector/jdbc/GenericJdbcExecutorTest.java connector/connector-generic-jdbc/src/main/java/org/apache/sqoop/connector/jdbc/GenericJdbcValidator.java connector/connector-generic-jdbc/src/main/java/org/apache/sqoop/connector/jdbc/configuration/ExportTableForm.java test/src/test/java/org/apache/sqoop/integration/connector/jdbc/generic/exports/TableStagedExportTest.java connector/connector-generic-jdbc/src/main/java/org/apache/sqoop/connector/jdbc/GenericJdbcExportDestroyer.java connector/connector-generic-jdbc/src/main/java/org/apache/sqoop/connector/jdbc/GenericJdbcExecutor.java connector/connector-generic-jdbc/src/test/java/org/apache/sqoop/connector/jdbc/TestExportInitializer.java connector/connector-generic-jdbc/src/main/resources/generic-jdbc-connector-resources.properties
          Hide
          Hudson added a comment -

          SUCCESS: Integrated in Sqoop2-hadoop200 #505 (See https://builds.apache.org/job/Sqoop2-hadoop200/505/)
          SQOOP-974: Sqoop2: Add staging table support to generic jdbc export job (jarcec: https://git-wip-us.apache.org/repos/asf?p=sqoop.git&a=commit&h=e33d6934761b66f24a7d197aacc3d40ea00f8155)

          • connector/connector-generic-jdbc/src/main/java/org/apache/sqoop/connector/jdbc/GenericJdbcValidator.java
          • connector/connector-generic-jdbc/src/main/java/org/apache/sqoop/connector/jdbc/GenericJdbcExportDestroyer.java
          • connector/connector-generic-jdbc/src/main/java/org/apache/sqoop/connector/jdbc/configuration/ExportTableForm.java
          • connector/connector-generic-jdbc/src/main/java/org/apache/sqoop/connector/jdbc/GenericJdbcExportInitializer.java
          • connector/connector-generic-jdbc/src/main/resources/generic-jdbc-connector-resources.properties
          • connector/connector-generic-jdbc/src/test/java/org/apache/sqoop/connector/jdbc/TestExportInitializer.java
          • connector/connector-generic-jdbc/src/main/java/org/apache/sqoop/connector/jdbc/GenericJdbcExecutor.java
          • connector/connector-generic-jdbc/src/main/java/org/apache/sqoop/connector/jdbc/GenericJdbcConnectorError.java
          • connector/connector-generic-jdbc/src/test/java/org/apache/sqoop/connector/jdbc/GenericJdbcExecutorTest.java
          • test/src/test/java/org/apache/sqoop/integration/connector/jdbc/generic/exports/TableStagedExportTest.java
          Show
          Hudson added a comment - SUCCESS: Integrated in Sqoop2-hadoop200 #505 (See https://builds.apache.org/job/Sqoop2-hadoop200/505/ ) SQOOP-974 : Sqoop2: Add staging table support to generic jdbc export job (jarcec: https://git-wip-us.apache.org/repos/asf?p=sqoop.git&a=commit&h=e33d6934761b66f24a7d197aacc3d40ea00f8155 ) connector/connector-generic-jdbc/src/main/java/org/apache/sqoop/connector/jdbc/GenericJdbcValidator.java connector/connector-generic-jdbc/src/main/java/org/apache/sqoop/connector/jdbc/GenericJdbcExportDestroyer.java connector/connector-generic-jdbc/src/main/java/org/apache/sqoop/connector/jdbc/configuration/ExportTableForm.java connector/connector-generic-jdbc/src/main/java/org/apache/sqoop/connector/jdbc/GenericJdbcExportInitializer.java connector/connector-generic-jdbc/src/main/resources/generic-jdbc-connector-resources.properties connector/connector-generic-jdbc/src/test/java/org/apache/sqoop/connector/jdbc/TestExportInitializer.java connector/connector-generic-jdbc/src/main/java/org/apache/sqoop/connector/jdbc/GenericJdbcExecutor.java connector/connector-generic-jdbc/src/main/java/org/apache/sqoop/connector/jdbc/GenericJdbcConnectorError.java connector/connector-generic-jdbc/src/test/java/org/apache/sqoop/connector/jdbc/GenericJdbcExecutorTest.java test/src/test/java/org/apache/sqoop/integration/connector/jdbc/generic/exports/TableStagedExportTest.java
          Jarek Jarcec Cecho made changes -
          Status Patch Available [ 10002 ] Resolved [ 5 ]
          Fix Version/s 1.99.3 [ 12324298 ]
          Fix Version/s 2.0.0 [ 12319272 ]
          Resolution Fixed [ 1 ]
          Hide
          Jarek Jarcec Cecho added a comment -

          Thank you Raghav Kumar Gautam for your contribution!

          Show
          Jarek Jarcec Cecho added a comment - Thank you Raghav Kumar Gautam for your contribution!
          Hide
          ASF subversion and git services added a comment -

          Commit e33d6934761b66f24a7d197aacc3d40ea00f8155 in branch refs/heads/sqoop2 from Jarek Jarcec Cecho
          [ https://git-wip-us.apache.org/repos/asf?p=sqoop.git;h=e33d693 ]

          SQOOP-974: Sqoop2: Add staging table support to generic jdbc export job

          (Raghav Kumar Gautam via Jarek Jarcec Cecho)

          Show
          ASF subversion and git services added a comment - Commit e33d6934761b66f24a7d197aacc3d40ea00f8155 in branch refs/heads/sqoop2 from Jarek Jarcec Cecho [ https://git-wip-us.apache.org/repos/asf?p=sqoop.git;h=e33d693 ] SQOOP-974 : Sqoop2: Add staging table support to generic jdbc export job (Raghav Kumar Gautam via Jarek Jarcec Cecho)
          Hide
          Sqoop QA bot added a comment -

          Here are the results of testing the latest attachment
          https://issues.apache.org/jira/secure/attachment/12602375/sqoop-974.3.txt against branch sqoop2.

          Overall: +1 all checks pass

          SUCCESS: Clean was successful
          SUCCESS: Patch applied correctly
          SUCCESS: Patch add/modify test case
          SUCCESS: Patch compiled
          SUCCESS: All tests passed

          Console output: https://builds.apache.org/job/PreCommit-SQOOP-Build/142/console

          This message is automatically generated.

          Show
          Sqoop QA bot added a comment - Here are the results of testing the latest attachment https://issues.apache.org/jira/secure/attachment/12602375/sqoop-974.3.txt against branch sqoop2. Overall: +1 all checks pass SUCCESS: Clean was successful SUCCESS: Patch applied correctly SUCCESS: Patch add/modify test case SUCCESS: Patch compiled SUCCESS: All tests passed Console output: https://builds.apache.org/job/PreCommit-SQOOP-Build/142/console This message is automatically generated.
          Raghav Kumar Gautam made changes -
          Attachment sqoop-974.3.txt [ 12602375 ]
          Hide
          Sqoop QA bot added a comment -

          Here are the results of testing the latest attachment
          https://issues.apache.org/jira/secure/attachment/12601929/sqoop-974.txt against branch sqoop2.

          Overall: +1 all checks pass

          SUCCESS: Clean was successful
          SUCCESS: Patch applied correctly
          SUCCESS: Patch add/modify test case
          SUCCESS: Patch compiled
          SUCCESS: All tests passed

          Console output: https://builds.apache.org/job/PreCommit-SQOOP-Build/137/console

          This message is automatically generated.

          Show
          Sqoop QA bot added a comment - Here are the results of testing the latest attachment https://issues.apache.org/jira/secure/attachment/12601929/sqoop-974.txt against branch sqoop2. Overall: +1 all checks pass SUCCESS: Clean was successful SUCCESS: Patch applied correctly SUCCESS: Patch add/modify test case SUCCESS: Patch compiled SUCCESS: All tests passed Console output: https://builds.apache.org/job/PreCommit-SQOOP-Build/137/console This message is automatically generated.
          Raghav Kumar Gautam made changes -
          Remote Link This issue links to "Review board link (Web Link)" [ 12627 ]
          Raghav Kumar Gautam made changes -
          Status Open [ 1 ] Patch Available [ 10002 ]
          Raghav Kumar Gautam made changes -
          Attachment sqoop-974.txt [ 12601929 ]
          Hide
          Venkat Ranganathan added a comment -

          Good work on detailing the design. Thanks Raghav Kumar Gautam. Looks good.

          Show
          Venkat Ranganathan added a comment - Good work on detailing the design. Thanks Raghav Kumar Gautam . Looks good.
          Raghav Kumar Gautam made changes -
          Attachment StagingTableforSqoop-2.pdf [ 12595242 ]
          Raghav Kumar Gautam made changes -
          Assignee Raghav Kumar Gautam [ raghavgautam ]
          Jarek Jarcec Cecho made changes -
          Field Original Value New Value
          Fix Version/s 2.0.0 [ 12319272 ]
          Jarek Jarcec Cecho created issue -

            People

            • Assignee:
              Raghav Kumar Gautam
              Reporter:
              Jarek Jarcec Cecho
            • Votes:
              0 Vote for this issue
              Watchers:
              6 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Development