You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "Konstantin Bereznyakov (Jira)" <ji...@apache.org> on 2026/04/25 01:44:00 UTC
[jira] [Updated] (HIVE-29580) CBO: Ambiguous column reference not detected for duplicate alias inside a CTE
[ https://issues.apache.org/jira/browse/HIVE-29580?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Konstantin Bereznyakov updated HIVE-29580:
------------------------------------------
Summary: CBO: Ambiguous column reference not detected for duplicate alias inside a CTE (was: DBO: Ambiguous column reference not detected for duplicate alias inside a CTE)
> CBO: Ambiguous column reference not detected for duplicate alias inside a CTE
> -----------------------------------------------------------------------------
>
> Key: HIVE-29580
> URL: https://issues.apache.org/jira/browse/HIVE-29580
> Project: Hive
> Issue Type: Bug
> Reporter: Konstantin Bereznyakov
> Priority: Major
>
>
> The query
> {code:java}
> with bse as (
> select 'a' as delivery_date, concat('a') as delivery_date
> ),
> tpm as (
> select * from bse
> )
> select tpm.delivery_date
> from tpm;
> {code}
> "happily" works with CBO {*}on{*}, fails with "FAILED: SemanticException [Error 10007]: Ambiguous column reference delivery_date in bse" when CBO is *off*
>
--
This message was sent by Atlassian Jira
(v8.20.10#820010)