You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "ASF GitHub Bot (Jira)" <ji...@apache.org> on 2026/08/05 00:00: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 ]

ASF GitHub Bot updated HIVE-29580:
----------------------------------
    Labels: pull-request-available  (was: )

> 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
>            Assignee: Konstantin Bereznyakov
>            Priority: Major
>              Labels: pull-request-available
>
>  
> 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)