[HIVE-2842] Table with column that shares name fails upon query

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Assignee: Unassigned
• Reporter: Kevin Wilfong
• Created: 06/Mar/12 18:18
• Updated: 19/Mar/12 00:48

Description

CREATE TABLE t (t STRING);
SELECT t FROM t;

This will result in
FAILED: Error in semantic analysis: Line 1:7 Ambiguous table alias or column reference 't'

Similarly
SELECT t2 FROM t t2;
will result in the same exception

SELECT t from t t2;
will succeed.

MySQL apparently supports this, so Hive should as well.

Issue Links

• duplicates: HIVE-2863 Ambiguous table name or column reference message displays when table and column names are the same