[
https://issues.apache.org/jira/browse/HIVE-4143?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Ashutosh Chauhan updated HIVE-4143:
-----------------------------------
Assignee: Ashutosh Chauhan
Release Note: (was: 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})
Status: Patch Available (was: Open)
Patch available at https://reviews.facebook.net/D9261
> 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
>
--
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
