[
https://issues.apache.org/jira/browse/HIVE-3972?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13780916#comment-13780916
]
Ashutosh Chauhan commented on HIVE-3972:
----------------------------------------
[~navis] HIVE-3562 and HIVE-1402 are in now. In light of that, is this
optimization still relevant? Are there any queries which may see still further
benefits from this patch even after both of those optimizations are on.
> Support using multiple reducer for fetching order by results
> ------------------------------------------------------------
>
> Key: HIVE-3972
> URL: https://issues.apache.org/jira/browse/HIVE-3972
> Project: Hive
> Issue Type: Improvement
> Components: Query Processor
> Reporter: Navis
> Assignee: Navis
> Priority: Minor
> Attachments: HIVE-3972.D8349.1.patch, HIVE-3972.D8349.2.patch,
> HIVE-3972.D8349.3.patch, HIVE-3972.D8349.4.patch
>
>
> Queries for fetching results which have lastly "order by" clause make final
> MR run with single reducer, which can be too much. For example,
> {code}
> select value, sum(key) as sum from src group by value order by sum;
> {code}
> If number of reducer is reasonable, multiple result files could be merged
> into single sorted stream in the fetcher level.
--
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
