Soumyakanti Das created HIVE-27761:
--------------------------------------
Summary: SemanticException for Nested CTEs
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
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)
