[
https://issues.apache.org/jira/browse/HIVE-27761?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Krisztian Kasa resolved HIVE-27761.
-----------------------------------
Resolution: Fixed
Merged to master. Thanks [~soumyakanti.das] for the patch.
> Compilation of nested CTEs throws SemanticException
> ---------------------------------------------------
>
> Key: HIVE-27761
> URL: https://issues.apache.org/jira/browse/HIVE-27761
> Project: Hive
> Issue Type: Bug
> Components: Hive
> Reporter: Soumyakanti Das
> Assignee: Soumyakanti Das
> Priority: Major
> Labels: pull-request-available
>
> Currently, nested CTEs are not supported in Hive. Simple repro:
> {code:java}
> with
> test1 as (
> with t1 as (select 1)
> select 1
> )
> select * from test1;
> org.apache.hadoop.hive.ql.parse.SemanticException: Line 5:13 Ambiguous table
> alias 't1'
> at
> org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.processCTE(SemanticAnalyzer.java:1310)
> at
> org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.doPhase1(SemanticAnalyzer.java:1980)
> {code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
