Konstantin Bereznyakov created HIVE-29580:
---------------------------------------------
Summary: DBO: 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
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)
