[
https://issues.apache.org/jira/browse/HIVE-13936?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15427680#comment-15427680
]
Lefty Leverenz commented on HIVE-13936:
---------------------------------------
Does this need to be documented in the wiki? If so, please add a TODOC2.2
label to this JIRA issue.
row_number is mentioned here, without any details or examples:
* [Windowing and Analytics -- Enhancements to Hive QL |
https://cwiki.apache.org/confluence/display/Hive/LanguageManual+WindowingAndAnalytics#LanguageManualWindowingAndAnalytics-EnhancementstoHiveQL]
(see #3, Analytics functions)
> Add streaming support for row_number
> ------------------------------------
>
> Key: HIVE-13936
> URL: https://issues.apache.org/jira/browse/HIVE-13936
> Project: Hive
> Issue Type: Bug
> Components: Query Processor
> Reporter: Johndee Burks
> Assignee: Yongzhi Chen
> Fix For: 2.2.0
>
> Attachments: HIVE-13936.1.patch
>
>
> Without this support row_number will cause heap issues in reducers. Example
> query below against 10 million records will cause failure.
> {code}
> select a, row_number() over (partition by a order by a desc) as row_num from
> j100mil;
> {code}
> Same issue different function in JIRA HIVE-7062
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)