hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Navis (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-9528) SemanticException: Ambiguous column reference
Date Mon, 02 Feb 2015 00:54:34 GMT

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

Navis commented on HIVE-9528:
-----------------------------

[~ychena], before HIVE-7733, column information was overwritten by last column with same name,
which possibly making invalid result. Anyway, the query you've mentioned is not working in
mysql either (works in psql, though). Can we resolve this as a not-problem?

> SemanticException: Ambiguous column reference
> ---------------------------------------------
>
>                 Key: HIVE-9528
>                 URL: https://issues.apache.org/jira/browse/HIVE-9528
>             Project: Hive
>          Issue Type: Bug
>    Affects Versions: 0.14.0
>            Reporter: Yongzhi Chen
>
> When running the following query:
> {code}
> SELECT if( COUNT(*) = 0, 'true', 'false' ) as RESULT FROM ( select  *  from sim a join
sim2 b on a.simstr=b.simstr) app
> Error: Error while compiling statement: FAILED: SemanticException [Error 10007]: Ambiguous
column reference simstr in app (state=42000,code=10007)
> {code}
> This query works fine in hive 0.10
> In the apache trunk, following workaround will work:
> {code}
> SELECT if(COUNT(*) = 0, 'true', 'false') as RESULT FROM (select a.* from sim a join sim2
b on a.simstr=b.simstr) app;
> {code}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message