[jira] [Comment Edited] (HIVE-14590) CBO (Calcite Return Path) Incorrect result set when limit is present in one of the union branches

["Jesus Camacho Rodriguez (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/HIVE-14590?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15431675#comment-15431675 ] 

Jesus Camacho Rodriguez edited comment on HIVE-14590 at 8/22/16 9:50 PM:
-------------------------------------------------------------------------

I was thinking that maybe a subquery nested within another subquery could happen, and we only pull up SortLimit if hive.optimize.limittranspose is on. Thus, I hold the +1; I think we need to not only check children, but rather traverse the subtree below the Union and check its descendants.


was (Author: jcamachorodriguez):
I was thinking that maybe a subquery nested within another subquery could happen, and we only pull up SortLimit if hive.optimize.limittranspose is on. Thus, I hold the +1; I think we need to not only check children, but rather traverse the subtree below the Union and check the descendants of that operator.

> 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)