[HIVE-9528] SemanticException: Ambiguous column reference

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Not A Problem
• Affects Version/s: 0.14.0
• Assignee: Navis Ryu
• Reporter: Yongzhi Chen
• Created: 31/Jan/15 00:44
• Updated: 03/Feb/15 04:52
• Resolved: 03/Feb/15 04:52

Description

When running the following query:

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)

This query works fine in hive 0.10

In the apache trunk, following workaround will work:

SELECT if(COUNT(*) = 0, 'true', 'false') as RESULT FROM (select a.* from sim a join sim2 b on a.simstr=b.simstr) app;

Issue Links

• relates to: HIVE-7733 Ambiguous column reference error on query