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

Allow PPD when subject is not a column with grouping sets present

    XMLWordPrintableJSON

Details

    Description

      After HIVE-19653,  filters with only columns and constants are pushed down, but in some cases,  this may not work as well, for example:
      SET hive.cbo.enable=false;
      SELECT a, b, sum(s)
      FROM T1
      GROUP BY a, b GROUPING SETS ((a), (a, b))
      HAVING upper(a) = "AAA" AND sum(s) > 100;
       
      SELECT upper(a), b, sum(s)
      FROM T1
      GROUP BY upper(a), b GROUPING SETS ((upper(a)), (upper(a), b))
      HAVING upper(a) = "AAA" AND sum(s) > 100;
       
      The filters pushed down to GBY can be f(gbyKey) or gbyKey with udf ,  not only the column groupby keys.

      Attachments

        Issue Links

          Activity

            People

              dengzh Zhihua Deng
              dengzh Zhihua Deng
              Votes:
              0 Vote for this issue
              Watchers:
              1 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 - 50m
                  50m