Sqoop
  1. Sqoop
  2. SQOOP-885

Allow excluding some tables from import-all-tables tools

    Details

    • Type: Improvement Improvement
    • Status: Resolved
    • Priority: Minor Minor
    • Resolution: Fixed
    • Affects Version/s: 1.4.2
    • Fix Version/s: 1.4.4
    • Component/s: None
    • Labels:
      None

      Description

      Currently tool import-all-tables will import all tables from given database. However sometimes user wants to import all tables except one or two. Thus I believe that it might be useful to add parameter with list of tables that will be excluded from the import-all-tables.

      1. SQOOP-885.patch.1
        9 kB
        Abraham Elmahrek

        Issue Links

          Activity

          Transition Time In Source Status Execution Times Last Executer Last Execution Date
          Open Open Patch Available Patch Available
          43d 16h 58m 1 Jarek Jarcec Cecho 26/Mar/13 14:11
          Patch Available Patch Available Resolved Resolved
          1d 10h 50m 1 Jarek Jarcec Cecho 28/Mar/13 01:01
          Hide
          Hudson added a comment -

          Integrated in Sqoop-ant-jdk-1.6-hadoop23 #814 (See https://builds.apache.org/job/Sqoop-ant-jdk-1.6-hadoop23/814/)
          SQOOP-885: Allow excluding some tables from import-all-tables tools (Revision 75bc21b16435457844c8a2dec8410abf5156f738)

          Result = SUCCESS
          jarcec : https://git-wip-us.apache.org/repos/asf?p=sqoop.git&a=commit&h=75bc21b16435457844c8a2dec8410abf5156f738
          Files :

          • src/java/org/apache/sqoop/tool/BaseSqoopTool.java
          • src/docs/user/import-all-tables.txt
          • src/java/org/apache/sqoop/tool/ImportAllTablesTool.java
          • src/java/org/apache/sqoop/SqoopOptions.java
          • src/test/com/cloudera/sqoop/TestAllTables.java
          • src/docs/man/sqoop-import-all-tables.txt
          Show
          Hudson added a comment - Integrated in Sqoop-ant-jdk-1.6-hadoop23 #814 (See https://builds.apache.org/job/Sqoop-ant-jdk-1.6-hadoop23/814/ ) SQOOP-885 : Allow excluding some tables from import-all-tables tools (Revision 75bc21b16435457844c8a2dec8410abf5156f738) Result = SUCCESS jarcec : https://git-wip-us.apache.org/repos/asf?p=sqoop.git&a=commit&h=75bc21b16435457844c8a2dec8410abf5156f738 Files : src/java/org/apache/sqoop/tool/BaseSqoopTool.java src/docs/user/import-all-tables.txt src/java/org/apache/sqoop/tool/ImportAllTablesTool.java src/java/org/apache/sqoop/SqoopOptions.java src/test/com/cloudera/sqoop/TestAllTables.java src/docs/man/sqoop-import-all-tables.txt
          Hide
          Hudson added a comment -

          Integrated in Sqoop-ant-jdk-1.6-hadoop100 #613 (See https://builds.apache.org/job/Sqoop-ant-jdk-1.6-hadoop100/613/)
          SQOOP-885: Allow excluding some tables from import-all-tables tools (Revision 75bc21b16435457844c8a2dec8410abf5156f738)

          Result = SUCCESS
          jarcec : https://git-wip-us.apache.org/repos/asf?p=sqoop.git&a=commit&h=75bc21b16435457844c8a2dec8410abf5156f738
          Files :

          • src/test/com/cloudera/sqoop/TestAllTables.java
          • src/java/org/apache/sqoop/tool/BaseSqoopTool.java
          • src/java/org/apache/sqoop/tool/ImportAllTablesTool.java
          • src/docs/user/import-all-tables.txt
          • src/java/org/apache/sqoop/SqoopOptions.java
          • src/docs/man/sqoop-import-all-tables.txt
          Show
          Hudson added a comment - Integrated in Sqoop-ant-jdk-1.6-hadoop100 #613 (See https://builds.apache.org/job/Sqoop-ant-jdk-1.6-hadoop100/613/ ) SQOOP-885 : Allow excluding some tables from import-all-tables tools (Revision 75bc21b16435457844c8a2dec8410abf5156f738) Result = SUCCESS jarcec : https://git-wip-us.apache.org/repos/asf?p=sqoop.git&a=commit&h=75bc21b16435457844c8a2dec8410abf5156f738 Files : src/test/com/cloudera/sqoop/TestAllTables.java src/java/org/apache/sqoop/tool/BaseSqoopTool.java src/java/org/apache/sqoop/tool/ImportAllTablesTool.java src/docs/user/import-all-tables.txt src/java/org/apache/sqoop/SqoopOptions.java src/docs/man/sqoop-import-all-tables.txt
          Hide
          Hudson added a comment -

          Integrated in Sqoop-ant-jdk-1.6-hadoop200 #603 (See https://builds.apache.org/job/Sqoop-ant-jdk-1.6-hadoop200/603/)
          SQOOP-885: Allow excluding some tables from import-all-tables tools (Revision 75bc21b16435457844c8a2dec8410abf5156f738)

          Result = SUCCESS
          jarcec : https://git-wip-us.apache.org/repos/asf?p=sqoop.git&a=commit&h=75bc21b16435457844c8a2dec8410abf5156f738
          Files :

          • src/docs/man/sqoop-import-all-tables.txt
          • src/test/com/cloudera/sqoop/TestAllTables.java
          • src/java/org/apache/sqoop/tool/BaseSqoopTool.java
          • src/docs/user/import-all-tables.txt
          • src/java/org/apache/sqoop/tool/ImportAllTablesTool.java
          • src/java/org/apache/sqoop/SqoopOptions.java
          Show
          Hudson added a comment - Integrated in Sqoop-ant-jdk-1.6-hadoop200 #603 (See https://builds.apache.org/job/Sqoop-ant-jdk-1.6-hadoop200/603/ ) SQOOP-885 : Allow excluding some tables from import-all-tables tools (Revision 75bc21b16435457844c8a2dec8410abf5156f738) Result = SUCCESS jarcec : https://git-wip-us.apache.org/repos/asf?p=sqoop.git&a=commit&h=75bc21b16435457844c8a2dec8410abf5156f738 Files : src/docs/man/sqoop-import-all-tables.txt src/test/com/cloudera/sqoop/TestAllTables.java src/java/org/apache/sqoop/tool/BaseSqoopTool.java src/docs/user/import-all-tables.txt src/java/org/apache/sqoop/tool/ImportAllTablesTool.java src/java/org/apache/sqoop/SqoopOptions.java
          Hide
          Hudson added a comment -

          Integrated in Sqoop-ant-jdk-1.6-hadoop20 #602 (See https://builds.apache.org/job/Sqoop-ant-jdk-1.6-hadoop20/602/)
          SQOOP-885: Allow excluding some tables from import-all-tables tools (Revision 75bc21b16435457844c8a2dec8410abf5156f738)

          Result = SUCCESS
          jarcec : https://git-wip-us.apache.org/repos/asf?p=sqoop.git&a=commit&h=75bc21b16435457844c8a2dec8410abf5156f738
          Files :

          • src/test/com/cloudera/sqoop/TestAllTables.java
          • src/java/org/apache/sqoop/SqoopOptions.java
          • src/docs/man/sqoop-import-all-tables.txt
          • src/docs/user/import-all-tables.txt
          • src/java/org/apache/sqoop/tool/ImportAllTablesTool.java
          • src/java/org/apache/sqoop/tool/BaseSqoopTool.java
          Show
          Hudson added a comment - Integrated in Sqoop-ant-jdk-1.6-hadoop20 #602 (See https://builds.apache.org/job/Sqoop-ant-jdk-1.6-hadoop20/602/ ) SQOOP-885 : Allow excluding some tables from import-all-tables tools (Revision 75bc21b16435457844c8a2dec8410abf5156f738) Result = SUCCESS jarcec : https://git-wip-us.apache.org/repos/asf?p=sqoop.git&a=commit&h=75bc21b16435457844c8a2dec8410abf5156f738 Files : src/test/com/cloudera/sqoop/TestAllTables.java src/java/org/apache/sqoop/SqoopOptions.java src/docs/man/sqoop-import-all-tables.txt src/docs/user/import-all-tables.txt src/java/org/apache/sqoop/tool/ImportAllTablesTool.java src/java/org/apache/sqoop/tool/BaseSqoopTool.java
          Jarek Jarcec Cecho made changes -
          Status Patch Available [ 10002 ] Resolved [ 5 ]
          Resolution Fixed [ 1 ]
          Hide
          Jarek Jarcec Cecho added a comment -
          Show
          Jarek Jarcec Cecho added a comment - The patch is in: https://git-wip-us.apache.org/repos/asf?p=sqoop.git;a=commit;h=75bc21b16435457844c8a2dec8410abf5156f738 Thank you Abe for your contribution! Jarcec
          Abraham Elmahrek made changes -
          Attachment SQOOP-885.patch.1 [ 12575740 ]
          Jarek Jarcec Cecho made changes -
          Status Open [ 1 ] Patch Available [ 10002 ]
          Fix Version/s 1.4.4 [ 12324082 ]
          Hide
          Jarek Jarcec Cecho added a comment -

          I'm setting the jira to "path available" state, so that it will show up in review queue.

          Show
          Jarek Jarcec Cecho added a comment - I'm setting the jira to "path available" state, so that it will show up in review queue.
          Jarek Jarcec Cecho made changes -
          Remote Link This issue links to "Review board (Web Link)" [ 12114 ]
          Abraham Elmahrek made changes -
          Field Original Value New Value
          Assignee Abraham Elmahrek [ abec ]
          Jarek Jarcec Cecho created issue -

            People

            • Assignee:
              Abraham Elmahrek
              Reporter:
              Jarek Jarcec Cecho
            • Votes:
              1 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Development