Chun Chen created HIVE-5358:
-------------------------------

             Summary: ReduceSinkDeDuplication should ignore column orders when 
check overlapping part of keys between parent and child
                 Key: HIVE-5358
                 URL: https://issues.apache.org/jira/browse/HIVE-5358
             Project: Hive
          Issue Type: Improvement
          Components: Query Processor
            Reporter: Chun Chen
            Assignee: Chun Chen


{code}
select key, value from (select key, value from src group by key, value) t group 
by key, value;
{code}
This can be optimized by ReduceSinkDeDuplication

{code}
select key, value from (select key, value from src group by key, value) t group 
by value, key;
{code}
However the sql above can't be optimized by ReduceSinkDeDuplication currently 
due to different column orders of parent and child operator.


--
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