[HIVE-5358] ReduceSinkDeDuplication should ignore column orders when check overlapping part of keys between parent and child

• Type: Improvement
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Component/s: Query Processor
• Assignee: Chun Chen
• Reporter: Chun Chen
• Created: 25/Sep/13 07:46
• Updated: 20/Oct/13 16:07

Description

select key, value from (select key, value from src group by key, value) t group by key, value;

This can be optimized by ReduceSinkDeDuplication

select key, value from (select key, value from src group by key, value) t group by value, key;

However the sql above can't be optimized by ReduceSinkDeDuplication currently due to different column orders of parent and child operator.