[
https://issues.apache.org/jira/browse/HIVE-1977?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13250203#comment-13250203
]
Zhenxiao Luo commented on HIVE-1977:
------------------------------------
@Carl: Get it. Should follow the correct syntax.
In summary, should support the following:
1. $describe table;
2. $describe database.table;
3. $describe table column;
4. $describe database.table column;
5. $describe table.column;
6. $describe database.table.column;
Currently,
#1 is working
#2 is error out for database not a valid table name
#3 and #4 are having exceptions for invalid syntax
#5 is working
How about #6, are we going to support it?
currently, #6 also error out for database not a valid table name
And, to distinguish #2 and #5, a new configuration property is needed, or we
try both, and error out only if neither matches?
> 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
