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

Introduce setting to set lower bound of hash aggregation reduction.

    XMLWordPrintableJSON

Details

    Description

      • Default setting of hash group by min reduction % is 0.99. 
      • During compilation, we check its effectiveness and adjust it accordingly in SetHashGroupByMinReduction:
        float defaultMinReductionHashAggrFactor = desc.getMinReductionHashAggr();
        float minReductionHashAggrFactor = 1f - ((float) ndvProduct / numRows);
        if (minReductionHashAggrFactor < defaultMinReductionHashAggrFactor) {
              desc.setMinReductionHashAggr(minReductionHashAggrFactor);
        }
        

        For certain queries, this computation turns out to be "0".

      This forces operator to skip HashAggregates completely and always ends up choosing streaming mode.

      Attachments

        Issue Links

          Activity

            People

              kkasa Krisztian Kasa
              kkasa Krisztian Kasa
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 20m
                  20m