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

Carl Steinbach commented on HIVE-1977:
--------------------------------------

bq. 3. $describe column;

This doesn't make sense since tables in the same schema are allowed to have 
columns with the same name. The correct syntax for describing a column is:

DESCRIBE table column

or

DESCRIBE db.table 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
>
> 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 is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: 
https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

Reply via email to