Details

      Description

      MySQL and PostgreSQL don't export views in direct modes. MySQL just silently ignores any views when running mysqldump and Postgres gives an error message.

      There's probably no easy way to detect if something is a view but this should at least go into the documentation I suppose.

      http://postgresql.1045698.n5.nabble.com/is-there-a-reason-we-can-t-copy-from-a-view-td2851875.html

      1. SQOOP-410.patch
        1 kB
        Jarek Jarcec Cecho
      2. SQOOP-410.patch
        1 kB
        Jarek Jarcec Cecho

        Issue Links

          Activity

          Lars Francke created issue -
          Jarek Jarcec Cecho made changes -
          Field Original Value New Value
          Assignee Jarek Jarcec Cecho [ jarcec ]
          Jarek Jarcec Cecho made changes -
          Remote Link This issue links to "Review board (Web Link)" [ 10419 ]
          Jarek Jarcec Cecho made changes -
          Attachment SQOOP-410.patch [ 12538576 ]
          Jarek Jarcec Cecho made changes -
          Status Open [ 1 ] Patch Available [ 10002 ]
          Jarek Jarcec Cecho made changes -
          Fix Version/s 1.4.2 [ 12320141 ]
          Hide
          Kathleen Ting added a comment -

          Hi Jarcec, it appears that the most recent diff on review board does not match up with the SQOOP-410.patch attached here. May I ask you to please upload the latest version here? Thanks.

          Show
          Kathleen Ting added a comment - Hi Jarcec, it appears that the most recent diff on review board does not match up with the SQOOP-410 .patch attached here. May I ask you to please upload the latest version here? Thanks.
          Hide
          Jarek Jarcec Cecho added a comment -

          Och, I've forgot to attach updated version to the JIRA after I've loaded it to the Review board. I've just uploaded same version as is available on review board.

          Please accept my apology for the inconvenience and thank you for noticing this!

          Jarcec

          Show
          Jarek Jarcec Cecho added a comment - Och, I've forgot to attach updated version to the JIRA after I've loaded it to the Review board. I've just uploaded same version as is available on review board. Please accept my apology for the inconvenience and thank you for noticing this! Jarcec
          Jarek Jarcec Cecho made changes -
          Attachment SQOOP-410.patch [ 12539062 ]
          Hide
          Kathleen Ting added a comment -

          Patch committed. Thanks Jarcec.

          Show
          Kathleen Ting added a comment - Patch committed. Thanks Jarcec.
          Kathleen Ting made changes -
          Status Patch Available [ 10002 ] Resolved [ 5 ]
          Resolution Fixed [ 1 ]
          Hide
          Hudson added a comment -

          Integrated in Sqoop-ant-jdk-1.6-hadoop20 #3 (See https://builds.apache.org/job/Sqoop-ant-jdk-1.6-hadoop20/3/)
          SQOOP-410. Direct modes can't import views
          (Jarek Jarcec Cecho via Kathlen Ting) (Revision 1369390)

          Result = FAILURE
          kathleen :
          Files :

          • /sqoop/trunk/src/docs/user/compatibility.txt
          Show
          Hudson added a comment - Integrated in Sqoop-ant-jdk-1.6-hadoop20 #3 (See https://builds.apache.org/job/Sqoop-ant-jdk-1.6-hadoop20/3/ ) SQOOP-410 . Direct modes can't import views (Jarek Jarcec Cecho via Kathlen Ting) (Revision 1369390) Result = FAILURE kathleen : Files : /sqoop/trunk/src/docs/user/compatibility.txt
          Hide
          Hudson added a comment -

          Integrated in Sqoop-ant-jdk-1.6-hadoop100 #3 (See https://builds.apache.org/job/Sqoop-ant-jdk-1.6-hadoop100/3/)
          SQOOP-410. Direct modes can't import views
          (Jarek Jarcec Cecho via Kathlen Ting) (Revision 1369390)

          Result = FAILURE
          kathleen :
          Files :

          • /sqoop/trunk/src/docs/user/compatibility.txt
          Show
          Hudson added a comment - Integrated in Sqoop-ant-jdk-1.6-hadoop100 #3 (See https://builds.apache.org/job/Sqoop-ant-jdk-1.6-hadoop100/3/ ) SQOOP-410 . Direct modes can't import views (Jarek Jarcec Cecho via Kathlen Ting) (Revision 1369390) Result = FAILURE kathleen : Files : /sqoop/trunk/src/docs/user/compatibility.txt
          Hide
          Hudson added a comment -

          Integrated in Sqoop-ant-jdk-1.6-hadoop23 #134 (See https://builds.apache.org/job/Sqoop-ant-jdk-1.6-hadoop23/134/)
          SQOOP-410. Direct modes can't import views
          (Jarek Jarcec Cecho via Kathlen Ting) (Revision 1369390)

          Result = FAILURE
          kathleen :
          Files :

          • /sqoop/trunk/src/docs/user/compatibility.txt
          Show
          Hudson added a comment - Integrated in Sqoop-ant-jdk-1.6-hadoop23 #134 (See https://builds.apache.org/job/Sqoop-ant-jdk-1.6-hadoop23/134/ ) SQOOP-410 . Direct modes can't import views (Jarek Jarcec Cecho via Kathlen Ting) (Revision 1369390) Result = FAILURE kathleen : Files : /sqoop/trunk/src/docs/user/compatibility.txt
          Hide
          Kathleen Ting added a comment -

          BUILD SUCCESSFUL
          Total time: 4 minutes 25 seconds
          [ci-game] evaluating rule: Build result
          [ci-game] scored: 1.0
          [ci-game] evaluating rule: Increased number of failed tests
          [ci-game] evaluating rule: Increased number of passed tests
          [ci-game] evaluating rule: Decreased number of failed tests
          [ci-game] evaluating rule: Decreased number of passed tests
          [ci-game] evaluating rule: Open HIGH priority tasks
          [ci-game] evaluating rule: Open NORMAL priority tasks
          [ci-game] evaluating rule: Open LOW priority tasks
          [ci-game] evaluating rule: PMD violation
          [ci-game] evaluating rule: pylint violation
          [ci-game] evaluating rule: CPD violation
          [ci-game] evaluating rule: Checkstyle violation
          [ci-game] evaluating rule: FindBugs violation
          [ci-game] evaluating rule: FXCop violation
          [ci-game] evaluating rule: Simian violation
          [ci-game] evaluating rule: StyleCop violation
          [ci-game] evaluating rule: HIGH priority PMD warnings
          [ci-game] evaluating rule: NORMAL priority PMD warnings
          [ci-game] evaluating rule: LOW priority PMD warnings
          [ci-game] evaluating rule: New HIGH priority Findbugs warnings
          [ci-game] evaluating rule: New NORMAL priority Findbugs warnings
          [ci-game] evaluating rule: New LOW priority Findbugs warnings
          [ci-game] evaluating rule: Fixed HIGH priority Findbugs warnings
          [ci-game] evaluating rule: Fixed NORMAL priority Findbugs warnings
          [ci-game] evaluating rule: Fixed LOW priority Findbugs warnings
          [ci-game] evaluating rule: Changed number of compiler warnings
          No emails were triggered.
          Finished: SUCCESS

          https://builds.apache.org/job/Sqoop-ant-jdk-1.6-hadoop23/136/console

          Show
          Kathleen Ting added a comment - BUILD SUCCESSFUL Total time: 4 minutes 25 seconds [ci-game] evaluating rule: Build result [ci-game] scored: 1.0 [ci-game] evaluating rule: Increased number of failed tests [ci-game] evaluating rule: Increased number of passed tests [ci-game] evaluating rule: Decreased number of failed tests [ci-game] evaluating rule: Decreased number of passed tests [ci-game] evaluating rule: Open HIGH priority tasks [ci-game] evaluating rule: Open NORMAL priority tasks [ci-game] evaluating rule: Open LOW priority tasks [ci-game] evaluating rule: PMD violation [ci-game] evaluating rule: pylint violation [ci-game] evaluating rule: CPD violation [ci-game] evaluating rule: Checkstyle violation [ci-game] evaluating rule: FindBugs violation [ci-game] evaluating rule: FXCop violation [ci-game] evaluating rule: Simian violation [ci-game] evaluating rule: StyleCop violation [ci-game] evaluating rule: HIGH priority PMD warnings [ci-game] evaluating rule: NORMAL priority PMD warnings [ci-game] evaluating rule: LOW priority PMD warnings [ci-game] evaluating rule: New HIGH priority Findbugs warnings [ci-game] evaluating rule: New NORMAL priority Findbugs warnings [ci-game] evaluating rule: New LOW priority Findbugs warnings [ci-game] evaluating rule: Fixed HIGH priority Findbugs warnings [ci-game] evaluating rule: Fixed NORMAL priority Findbugs warnings [ci-game] evaluating rule: Fixed LOW priority Findbugs warnings [ci-game] evaluating rule: Changed number of compiler warnings No emails were triggered. Finished: SUCCESS https://builds.apache.org/job/Sqoop-ant-jdk-1.6-hadoop23/136/console

            People

            • Assignee:
              Jarek Jarcec Cecho
              Reporter:
              Lars Francke
            • Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Development