Details
-
Improvement
-
Status: Open
-
Major
-
Resolution: Unresolved
-
None
-
None
-
None
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.