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:05:00 UTC
[jira] [Updated] (HIVE-27761) Compilation of nested CTEs throws SemanticException
[ https://issues.apache.org/jira/browse/HIVE-27761?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Soumyakanti Das updated HIVE-27761:
-----------------------------------
Summary: Compilation of nested CTEs throws SemanticException (was: SemanticException for Nested CTEs)
> 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
>
> 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)