hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Carl Steinbach (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-6187) Cannot use backticks around table name when using DESCRIBE query
Date Mon, 12 May 2014 09:39:15 GMT

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

Mime
View raw message