[
https://issues.apache.org/jira/browse/HIVE-29580?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Konstantin Bereznyakov reassigned HIVE-29580:
---------------------------------------------
Assignee: Konstantin Bereznyakov
> 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
>
>
> 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)
