[HIVE-4143] Incorrect column mappings with over clause

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 0.11.0
• Component/s: PTF-Windowing
• Assignee: Ashutosh Chauhan
• Reporter: Ashutosh Chauhan
• Created: 09/Mar/13 17:04
• Updated: 16/May/13 21:10
• Resolved: 12/Mar/13 01:48

Description

Following query generates 3 MR job and fails in reducer initialization phase of third job.

select ts, dec, rnk
from
  (select ts, dec,
          rank() over (partition by ts order by item_total desc)  as rnk
          from
            (select other.ts, other.dec, sum(other.i) as item_total
             from over10k other
             join over10k on (other.b = over10k.b)
             group by other.ts, other.dec
            ) item_sales
  ) item_rank
where rnk <=  3;