[jira] [Commented] (HIVE-9528) SemanticException: Ambiguous column reference

["Navis (JIRA)" <ji...@apache.org>]

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