Gang Tim Liu created HIVE-3568:
----------------------------------

             Summary: No pushdown subquery's group by key in outside filter
                 Key: HIVE-3568
                 URL: https://issues.apache.org/jira/browse/HIVE-3568
             Project: Hive
          Issue Type: Bug
          Components: Query Processor
            Reporter: Gang Tim Liu
            Priority: Minor


pushdown doesn't happen with group by in subquery and group by key in outside 
filter.
        
select * from (select x, count(1) from fact_daily where ds ='1' group by x) 
subq where x = 484;

subquery still scans the partition.

expect only scan x = 484.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira

Reply via email to