You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues-all@impala.apache.org by "Steve Carlin (Jira)" <ji...@apache.org> on 2025/10/08 17:41:00 UTC

[jira] [Created] (IMPALA-14483) Incorrect results when group is duplicated in grouping sets

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: issues-all-unsubscribe@impala.apache.org
For additional commands, e-mail: issues-all-help@impala.apache.org