[jira] [Commented] (HIVE-1977) DESCRIBE TABLE syntax doesn't support specifying a database qualified table name

["Lefty Leverenz (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/HIVE-1977?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14083734#comment-14083734 ] 

Lefty Leverenz commented on HIVE-1977:
--------------------------------------

This could be documented in the wiki, but [~thejas] recommended leaving it undocumented:

{quote}
Yes, DOT is also optional now, but I am not a fan of that syntax. It has
made it almost impossible
to extend describe statements to other commands, as you can see from
HIVE-5931<https://issues.apache.org/jira/browse/HIVE-5931?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13924779#comment-13924779>
.
Lets just document the syntax with DOT for now. That way it be easier to
fix the syntax later if we choose to.
{quote}

So if I get agreement here, I'll remove the TODOC10 label from this JIRA ticket.

* [Thejas's recommendation in dev@hive mailing list | http://markmail.org/message/r6vgnd27dkj2qnlr]
* [LanguageManual DDL -- Describe Table/View/Column | https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL#LanguageManualDDL-DescribeTable/View/Column]

> 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
>              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
(v6.2#6252)