[ 
https://issues.apache.org/jira/browse/HIVE-20215?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Vineet Garg updated HIVE-20215:
-------------------------------
    Summary: Hive unable to plan/compile query containing subquery with 
multiple same name columns  (was: Hive unable to plan/compile query)

> Hive unable to plan/compile query containing subquery with multiple same name 
> columns
> -------------------------------------------------------------------------------------
>
>                 Key: HIVE-20215
>                 URL: https://issues.apache.org/jira/browse/HIVE-20215
>             Project: Hive
>          Issue Type: Bug
>          Components: Query Planning
>            Reporter: Vineet Garg
>            Assignee: Vineet Garg
>            Priority: Major
>
> *Reproducer*
> ======================
> {code:sql}
> >create table t1(c1 int)
> >explain select count(*) from (select c1, c1 from t1) subq
> {code}
> {noformat}
> FAILED: SemanticException [Error 10007]: Ambiguous column reference c1 in subq
> {noformat}



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

Reply via email to