Steve Carlin created IMPALA-14483:
-------------------------------------
Summary: Incorrect results when group is duplicated in grouping
sets
Key: IMPALA-14483
URL: https://issues.apache.org/jira/browse/IMPALA-14483
Project: IMPALA
Issue Type: Bug
Reporter: Steve Carlin
For the following query:
{code:java}
select int_col, string_col, bool_col, count(*)
from functional.alltypesagg
group by grouping sets((int_col), (string_col), (int_col, bool_col),
(int_col, bool_col))
order by count(*) desc, 1, 2, 3
limit 21
{code}
Note the (int_col, bool_col) grouping set is duplicated. This should result in
the data for this grouping set also being duplicated, but this is not happening.
This was found while testing queries for the Calcite planner (IMPALA-14222).
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
