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