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

["Naveen Gangam (JIRA)" <ji...@apache.org>]

    [ 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)