Gopal Vijayaraghavan created HIVE-22448:
-------------------------------------------

             Summary: CBO: Expand the multiple count distinct with a group-by 
key
                 Key: HIVE-22448
                 URL: https://issues.apache.org/jira/browse/HIVE-22448
             Project: Hive
          Issue Type: Bug
            Reporter: Gopal Vijayaraghavan


{code}
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 z, x, count(distinct y), count(distinct a)
from mytable1
{code}

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



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

Reply via email to