[
https://issues.apache.org/jira/browse/HIVE-11241?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15033935#comment-15033935
]
Naveen Gangam commented on HIVE-11241:
--------------------------------------
The ambiguous grammer has been fixed in HIVE-12184 in Hive 2.0. Should this
jira be closed as dup?
> Database prefix does not work properly if table has same name
> -------------------------------------------------------------
>
> Key: HIVE-11241
> URL: https://issues.apache.org/jira/browse/HIVE-11241
> Project: Hive
> Issue Type: Bug
> Components: Database/Schema
> Reporter: Johndee Burks
> Assignee: Ferdinand Xu
> Attachments: HIVE-11241.patch
>
>
> If you do the following it will fail:
> {code}
> 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)
> {code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)