[ https://issues.apache.org/jira/browse/HIVE-12644?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15064891#comment-15064891 ]
Laljo John Pullokkaran commented on HIVE-12644: ----------------------------------------------- As we discussed, need to simplify the logic about limit overlaps (Top Limit & Bottom Limit): 1. Fully contained 2. Partially contained 3. Outside > 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)