[
https://issues.apache.org/jira/browse/HIVE-4143?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Ashutosh Chauhan updated HIVE-4143:
-----------------------------------
Description:
Following query generates 3 MR job and fails in reducer initialization phase of
third job.
{code}
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;
{code}
> Incorrect column mappings with over clause
> ------------------------------------------
>
> Key: HIVE-4143
> URL: https://issues.apache.org/jira/browse/HIVE-4143
> Project: Hive
> Issue Type: Bug
> Components: PTF-Windowing
> Reporter: Ashutosh Chauhan
> Assignee: Ashutosh Chauhan
>
> Following query generates 3 MR job and fails in reducer initialization phase
> of third job.
> {code}
> 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;
> {code}
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
