[HIVE-2863] Ambiguous table name or column reference message displays when table and column names are the same

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 0.9.0
• Hadoop Flags: Reviewed
• Assignee: Navis Ryu
• Reporter: Mauro Cazzari
• Created: 12/Mar/12 15:24
• Updated: 09/Jan/13 10:25
• Resolved: 05/Apr/12 23:07

Description

Given the following table:

CREATE TABLE `Y` (`y` DOUBLE) ROW FORMAT DELIMITED FIELDS TERMINATED BY '\001' STORED AS TEXTFILE;

The following query fails:

SELECT `Y`.`y` FROM `Y` WHERE ( `y` = 1 )
ERROR: java.sql.SQLException: Query returned non-zero code: 10, cause: FAILED: Error in
semantic analysis: Line 1:36 Ambiguous table alias or column reference '`y`'
ERROR: Unable to execute Hadoop query.
ERROR: Prepare error. SQL statement: SELECT `Y`.`y` FROM `Y` WHERE ( `y` = 1 ).

The problem goes away if the table and column names do not match.

Issue Links

• is duplicated by: HIVE-2842 Table with column that shares name fails upon query