Details
-
Improvement
-
Status: Closed
-
Major
-
Resolution: Fixed
-
2.2.0
Description
Pointed out by gopalv.
RS dedup should kick in for these cases, avoiding an additional shuffle stage.
select state, city, sum(sales) from table group by state, city order by state, city limit 10;
select state, city, sum(sales) from table group by city, state order by state, city limit 10;
select state, city, sum(sales) from table group by city, state order by state desc, city limit 10;
Attachments
Attachments
Issue Links
- is related to
-
HIVE-14095 Simplify decision logic to execute RS dedup for Join operators
- Open
-
HIVE-14096 Extend RS dedup logic to merge GBy operators
- Open
- links to