[HIVE-13982] Extensions to RS dedup: execute with different column order and sorting direction if possible

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 2.2.0
• Fix Version/s: 2.1.1, 2.2.0
• Component/s: Physical Optimizer
• Labels: TODOC2.1.1 TODOC2.2
• Assignee: Jesús Camacho Rodríguez
• Reporter: Jesús Camacho Rodríguez
• Created: 09/Jun/16 18:28
• Updated: 27/Feb/24 22:24
• Resolved: 26/Jun/16 02:18

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;

Issue Links

• is related to: HIVE-14095 Simplify decision logic to execute RS dedup for Join operators
• is related to: HIVE-14096 Extend RS dedup logic to merge GBy operators
• links to: RB link