You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "Vineet Garg (JIRA)" <ji...@apache.org> on 2018/07/27 23:16:00 UTC
[jira] [Resolved] (HIVE-20215) Hive unable to plan/compile query
containing subquery with multiple same name columns
[ https://issues.apache.org/jira/browse/HIVE-20215?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Vineet Garg resolved HIVE-20215.
--------------------------------
Resolution: Duplicate
> 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)