[ https://issues.apache.org/jira/browse/HIVE-11684?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15000513#comment-15000513 ]
Jesus Camacho Rodriguez commented on HIVE-11684: ------------------------------------------------ [~jpullokkaran], new patch (.17) addresses your comments. * 1. It is not necessary: we push Project through Sort iff we had previously pushed the Sort through the Project (this is checked through the "pushed" flag). It is true that all these rules are tightly coupled, but I think we can go this way at this moment. * 2., 3.a, and 3.b: addressed. About 3.b, we do not merge multiple Sort operations at the moment, i.e. the top Sort operator needs to be a pure Limit operation. > Implement limit pushdown through outer join in CBO > -------------------------------------------------- > > Key: HIVE-11684 > URL: https://issues.apache.org/jira/browse/HIVE-11684 > Project: Hive > Issue Type: New Feature > Components: CBO > Affects Versions: 2.0.0 > Reporter: Jesus Camacho Rodriguez > Assignee: Jesus Camacho Rodriguez > Attachments: HIVE-11684.01.patch, HIVE-11684.02.patch, > HIVE-11684.03.patch, HIVE-11684.04.patch, HIVE-11684.05.patch, > HIVE-11684.07.patch, HIVE-11684.08.patch, HIVE-11684.09.patch, > HIVE-11684.10.patch, HIVE-11684.11.patch, HIVE-11684.12.patch, > HIVE-11684.12.patch, HIVE-11684.14.patch, HIVE-11684.15.patch, > HIVE-11684.16.patch, HIVE-11684.17.patch, HIVE-11684.patch > > -- This message was sent by Atlassian JIRA (v6.3.4#6332)