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

Optimize sum(1) to answer query using metadata

    XMLWordPrintableJSON

Details

    • New Feature
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • None
    • 0.13.0
    • Query Processor, Statistics
    • None

    Description

      sum(1) has same semantics as count(1) so it can also be optimized in similar fashion by answering query using stats stored in metastore.

      Attachments

        1. HIVE-6192.patch
          26 kB
          Ashutosh Chauhan
        2. HIVE-6192.2.patch
          30 kB
          Ashutosh Chauhan

        Issue Links

          is part of

          Improvement - An improvement or enhancement to an existing feature or task. HIVE-5483 use metastore statistics to optimize max/min/etc. queries

          • Major - Major loss of function.
          • Resolved

          Activity

            People

              ashutoshc Ashutosh Chauhan
              ashutoshc Ashutosh Chauhan
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: