[
https://issues.apache.org/jira/browse/HIVE-14719?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15475360#comment-15475360
]
Ashutosh Chauhan commented on HIVE-14719:
-----------------------------------------
I don't understand how clearing out of rootNode fixes the issue. Once we set
new child in AST, previous one won't be accessible. So, how does this clearing
out of rootNode helps?
Also, why does this issue doesn't happen with cbo on?
> ASTNode rootNode is not maintained properly when changing child/parent
> relation
> -------------------------------------------------------------------------------
>
> Key: HIVE-14719
> URL: https://issues.apache.org/jira/browse/HIVE-14719
> Project: Hive
> Issue Type: Bug
> Reporter: Rui Li
> Assignee: Rui Li
> Attachments: HIVE-14719.1.patch
>
>
> When I run some query like:
> {code}
> set hive.cbo.enable=false;
> select * from A where exists (select * from B where B.k1=A.k1 and B.k2=A.k2);
> {code}
> It gets error like:
> {noformat}
> FAILED: SemanticException Line 0:-1 Invalid table alias or column reference
> 'sq_1': (possible column names are: _table_or_col b) k2) sq_corr_1)) (tok, (.
> (tok_table_or_col sq_1) sq_corr_1))
> {noformat}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
