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