[
https://issues.apache.org/jira/browse/HIVE-6187?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13994965#comment-13994965
]
Carl Steinbach commented on HIVE-6187:
--------------------------------------
I can confirm that this functionality is currently working on trunk, and also
that it's broken in the 0.12.0 release. I'm not sure when it was fixed, and
there doesn't appear to be any test coverage that will prevent someone from
breaking it again in the future.
> Cannot use backticks around table name when using DESCRIBE query
> ----------------------------------------------------------------
>
> Key: HIVE-6187
> URL: https://issues.apache.org/jira/browse/HIVE-6187
> Project: Hive
> Issue Type: Bug
> Affects Versions: 0.10.0
> Reporter: Andy Mok
>
> Backticks around tables named after special keywords, such as items, allow us
> to create, drop, and alter the table. For example
> {code:sql}
> CREATE TABLE foo.`items` (bar INT);
> DROP TABLE foo.`items`;
> ALTER TABLE `items` RENAME TO `items_`;
> {code}
> However, we cannot call
> {code:sql}
> DESCRIBE foo.`items`;
> DESCRIBE `items`;
> {code}
> The DESCRIBE query does not permit backticks to surround table names. The
> error returned is
> {code:sql}
> FAILED: SemanticException [Error 10001]: Table not found `items`
> {code}
--
This message was sent by Atlassian JIRA
(v6.2#6252)
