[ https://issues.apache.org/jira/browse/HIVE-14590?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15431320#comment-15431320 ]
Jesus Camacho Rodriguez commented on HIVE-14590: ------------------------------------------------ OK, thanks for the explanation, that makes sense. In that case, could you confirm that it is guaranteed that the limit operator will be just below the union? I think so, if I remember correctly... If that is guaranteed, patch LGTM, +1 > CBO (Calcite Return Path) Incorrect result set when limit is present in one > of the union branches > ------------------------------------------------------------------------------------------------- > > Key: HIVE-14590 > URL: https://issues.apache.org/jira/browse/HIVE-14590 > Project: Hive > Issue Type: Sub-task > Components: Logical Optimizer > Affects Versions: 2.0.0, 2.1.0 > Reporter: Ashutosh Chauhan > Assignee: Ashutosh Chauhan > Attachments: HIVE-14590.patch > > > Limit gets propagated outside union. -- This message was sent by Atlassian JIRA (v6.3.4#6332)