hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Vineet Garg (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-20215) Hive unable to plan/compile query containing subquery with multiple same name columns
Date Fri, 27 Jul 2018 23:16:00 GMT

    [ https://issues.apache.org/jira/browse/HIVE-20215?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16560460#comment-16560460
] 

Vineet Garg commented on HIVE-20215:
------------------------------------

This will be fixe in HIVE-19770

> 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)

Mime
View raw message