[
https://issues.apache.org/jira/browse/HIVE-1977?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17065872#comment-17065872
]
cai liangliang commented on HIVE-1977:
--------------------------------------
When desc tmp.table, there is a same table named tmp in default database, it
throw error. How to resolve it?
> DESCRIBE TABLE syntax doesn't support specifying a database qualified table
> name
> --------------------------------------------------------------------------------
>
> Key: HIVE-1977
> URL: https://issues.apache.org/jira/browse/HIVE-1977
> Project: Hive
> Issue Type: Bug
> Components: Database/Schema, Query Processor, SQL
> Reporter: Carl Steinbach
> Assignee: Zhenxiao Luo
> Priority: Major
> Labels: TODOC10
> Fix For: 0.10.0
>
> Attachments: HIVE-1977.1.patch.txt, HIVE-1977.2.patch.txt,
> HIVE-1977.3.patch.txt, HIVE-1977.4.patch.txt, HIVE-1977.5.patch.txt,
> HIVE-1977.6.patch.txt
>
>
> The syntax for DESCRIBE is broken. It should be:
> {code}
> DESCRIBE [EXTENDED] [database DOT]table [column]
> {code}
> but is actually
> {code}
> DESCRIBE [EXTENDED] table[DOT col_name]
> {code}
> Ref: http://dev.mysql.com/doc/refman/5.0/en/describe.html
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
