[HIVE-11241] Database prefix does not work properly if table has same name

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Duplicate
• Fix Version/s: 2.0.0
• Component/s: Database/Schema
• Assignee: Ferdinand Xu
• Reporter: Johndee Burks
• Created: 13/Jul/15 21:29
• Updated: 16/Feb/16 23:50
• Resolved: 02/Dec/15 00:58

Description

If you do the following it will fail:

0: jdbc:hive2://cdh54-1.test.com:10000/defaul> create database test4; 
No rows affected (0.881 seconds) 
0: jdbc:hive2://cdh54-1.test.com:10000/defaul> use test4; 
No rows affected (0.1 seconds) 
0: jdbc:hive2://cdh54-1.test.com:10000/defaul> create table test4 (c1 char(200)); 
No rows affected (0.306 seconds) 
0: jdbc:hive2://cdh54-1.test.com:10000/defaul> desc test4.test4; 
Error: Error while processing statement: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. cannot find field test4 from [0:c1] (state=08S01,code=1)

Issue Links

• duplicates: HIVE-12184 DESCRIBE of fully qualified table fails when db and table name match and non-default database is in use
• is related to: HIVE-11261 DESCRIBE database qualifier does not work when calling DESCRIBE on column or nested columns.