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

InformationSchemaManager.getPrimaryKeyQuery can take a very long time for large mysql table with partitions

    Details

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

      Description

      Since we are already verbose when starting a job it would be nice to log a message saying we are obtaining the primary key.

      1. SQOOP-487.patch
        0.7 kB
        Jarek Jarcec Cecho

        Issue Links

          Activity

          Hide
          hudson Hudson added a comment -

          Integrated in Sqoop-ant-jdk-1.6 #119 (See https://builds.apache.org/job/Sqoop-ant-jdk-1.6/119/)
          SQOOP-487 Log InformationSchemaManager.getPrimaryKeyQuery invocation (Revision 1345313)

          Result = SUCCESS
          blee :
          Files :

          • /sqoop/trunk/src/java/org/apache/sqoop/manager/CatalogQueryManager.java
          Show
          hudson Hudson added a comment - Integrated in Sqoop-ant-jdk-1.6 #119 (See https://builds.apache.org/job/Sqoop-ant-jdk-1.6/119/ ) SQOOP-487 Log InformationSchemaManager.getPrimaryKeyQuery invocation (Revision 1345313) Result = SUCCESS blee : Files : /sqoop/trunk/src/java/org/apache/sqoop/manager/CatalogQueryManager.java
          Hide
          bleeapache Bilung Lee added a comment -

          Thanks, Jarcec! Patch is committed.

          Show
          bleeapache Bilung Lee added a comment - Thanks, Jarcec! Patch is committed.
          Hide
          jarcec Jarek Jarcec Cecho added a comment -

          Attached patch do have granted Apache license even though that Apache icon is not visible (at least for me).

          Show
          jarcec Jarek Jarcec Cecho added a comment - Attached patch do have granted Apache license even though that Apache icon is not visible (at least for me).

            People

            • Assignee:
              jarcec Jarek Jarcec Cecho
              Reporter:
              brocknoland Brock Noland
            • Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Development