[jira] [Created] (DRILL-8381) Add support for filtered aggregate calls

["Vova Vysotskyi (Jira)" <ji...@apache.org>]

Vova Vysotskyi created DRILL-8381:
-------------------------------------

             Summary: Add support for filtered aggregate calls
                 Key: DRILL-8381
                 URL: https://issues.apache.org/jira/browse/DRILL-8381
             Project: Apache Drill
          Issue Type: New Feature
            Reporter: Vova Vysotskyi
            Assignee: Vova Vysotskyi


Currently, Drill ignores filters for filtered aggregate calls and returns incorrect results.
Here is the example query for which Drill will return incorrect results:
{code:sql}
SELECT count(n_name) FILTER(WHERE n_regionkey = 1) AS nations_count_in_1_region,
count(n_name) FILTER(WHERE n_regionkey = 2) AS nations_count_in_2_region,
count(n_name) FILTER(WHERE n_regionkey = 3) AS nations_count_in_3_region,
count(n_name) FILTER(WHERE n_regionkey = 4) AS nations_count_in_4_region,
count(n_name) FILTER(WHERE n_regionkey = 0) AS nations_count_in_0_region
FROM cp.`tpch/nation.parquet`
{code}

{noformat}
+---------------------------+---------------------------+---------------------------+---------------------------+---------------------------+
| nations_count_in_1_region | nations_count_in_2_region | nations_count_in_3_region | nations_count_in_4_region | nations_count_in_0_region |
+---------------------------+---------------------------+---------------------------+---------------------------+---------------------------+
| 25                        | 25                        | 25                        | 25                        | 25                        |
+---------------------------+---------------------------+---------------------------+---------------------------+---------------------------+
{noformat}

But correct result is
{noformat}
+---------------------------+---------------------------+---------------------------+---------------------------+---------------------------+
| nations_count_in_1_region | nations_count_in_2_region | nations_count_in_3_region | nations_count_in_4_region | nations_count_in_0_region |
+---------------------------+---------------------------+---------------------------+---------------------------+---------------------------+
| 5                         | 5                         | 5                         | 5                         | 5                         |
+---------------------------+---------------------------+---------------------------+---------------------------+---------------------------+
{noformat}



--
This message was sent by Atlassian Jira
(v8.20.10#820010)