Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-14204

Optimize loading dynamic partitions

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Closed
    • Minor
    • Resolution: Fixed
    • None
    • 2.2.0
    • Metastore

    Description

      Lots of time is spent in sequential fashion to load dynamic partitioned dataset in driver side. E.g simple dynamic partitioned load as follows takes 300+ seconds

      INSERT INTO web_sales_test partition(ws_sold_date_sk) select * from tpcds_bin_partitioned_orc_200.web_sales;


Time taken to load dynamic partitions: 309.22 seconds

      Attachments

        1. HIVE-14204.8.patch
          26 kB
          Rajesh Balamohan
        2. HIVE-14204.7.patch
          26 kB
          Rajesh Balamohan
        3. HIVE-14204.6.patch
          25 kB
          Rajesh Balamohan
        4. HIVE-14204.4.patch
          16 kB
          Rajesh Balamohan
        5. HIVE-14204.3.patch
          9 kB
          Rajesh Balamohan
        6. HIVE-14204.1.patch
          6 kB
          Rajesh Balamohan

        Issue Links

          is related to

          Bug - A problem which impairs or prevents the functions of the product. HIVE-16323 HS2 JDOPersistenceManagerFactory.pmCache leaks after HIVE-14204

          • Major - Major loss of function.
          • Closed

          Improvement - An improvement or enhancement to an existing feature or task. HIVE-8042 Optionally allow move tasks to run in parallel

          • Major - Major loss of function.
          • Closed
          relates to

          Improvement - An improvement or enhancement to an existing feature or task. HIVE-13925 ETL optimizations

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Open

          Activity

            People

              rajesh.balamohan Rajesh Balamohan
              rajesh.balamohan Rajesh Balamohan
              Votes:
              0 Vote for this issue
              Watchers:
              8 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: