You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@hive.apache.org by "Soumyakanti Das (Jira)" <ji...@apache.org> on 2023/09/29 18:03:00 UTC

[jira] [Created] (HIVE-27761) SemanticException for Nested CTEs

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)