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

Improve checkHashModeEfficiency in VectorGroupByOperator

    XMLWordPrintableJSON

    Details

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

      Description

      Currently, VectorGroupByOperator::checkHashModeEfficiency compares the number of entries with the number input records that have been processed. For grouping sets, it accounts for grouping set length as well.

      Issue is that, the condition becomes invalid after processing large number of input records. This prevents the system from switching over to streaming mode.

      e.g Assume 500,000 input records processed, with 9 grouping sets, with 100,000 entries in hashtable. Hashtable would never cross 4,500,0000 entries as the max size itself is 1M by default.

      It would be good to compare the input records (adjusted for grouping sets) with number of output records (along with size of hashtable size) to determine hashing or streaming mode.

      E.g Q67.

        Attachments

        1. HIVE-24234.wip.patch
          3 kB
          Rajesh Balamohan

          Issue Links

            Activity

              People

              • Assignee:
                rajesh.balamohan Rajesh Balamohan
                Reporter:
                rajesh.balamohan Rajesh Balamohan
              • Votes:
                0 Vote for this issue
                Watchers:
                4 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 - 40m
                  40m