[HIVE-22448] CBO: Expand the multiple count distinct with a group-by key

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 4.0.0-alpha-1
• Component/s: CBO
• Labels: pull-request-available
• Assignee: Jesús Camacho Rodríguez Assign to me
• Reporter: Gopal Vijayaraghavan
• Created: 02/Nov/19 01:53
• Updated: 27/Feb/24 22:24
• Resolved: 08/Nov/19 08:09

Description

create temporary table mytable1 (x integer, y integer, z integer, a integer);

explain cbo
select z, x, count(distinct y), count(distinct a)
from mytable1
group by z, x;


explain cbo
select count(distinct y), count(distinct a)
from mytable1

The first is not vectorized, the second one is because of the grouping-set based rewrite for count distinct.

Issue Links

• links to: GitHub Pull Request #838