[jira] [Commented] (HIVE-6187) Cannot use backticks around table name when using DESCRIBE query

["Carl Steinbach (JIRA)" <ji...@apache.org>]

    [ 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)