[
https://issues.apache.org/jira/browse/HIVE-12644?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15053937#comment-15053937
]
Laljo John Pullokkaran commented on HIVE-12644:
-----------------------------------------------
In HiveSortMergeRule @92 isn't it better to check if offset+limit is less than
the one from below.
i.e
if ((topOffset + topLimit) < (bottomOffset + bottomLimit))
> Support for offset in HiveSortMergeRule
> ---------------------------------------
>
> Key: HIVE-12644
> URL: https://issues.apache.org/jira/browse/HIVE-12644
> Project: Hive
> Issue Type: Bug
> Components: CBO
> Affects Versions: 2.1.0
> Reporter: Jesus Camacho Rodriguez
> Assignee: Jesus Camacho Rodriguez
> Attachments: HIVE-12644.patch
>
>
> After HIVE-11531 goes in, HiveSortMergeRule needs to be extended to support
> offset properly when it merges operators that contain Limit. Otherwise, limit
> pushdown through outer join optimization (introduced in HIVE-11684) will not
> work properly.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
