[HIVE-6187] Add test to verify that DESCRIBE TABLE works with quoted table names

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 0.10.0
• Fix Version/s: 0.14.0
• Labels: TODOC14
• Assignee: Carl Steinbach
• Reporter: Andy Mok
• Created: 10/Jan/14 23:54
• Updated: 27/Jan/15 09:21
• Resolved: 13/May/14 16:15

Description

Backticks around tables named after special keywords, such as items, allow us to create, drop, and alter the table. For example

CREATE TABLE foo.`items` (bar INT);
DROP TABLE foo.`items`;
ALTER TABLE `items` RENAME TO `items_`;

However, we cannot call

DESCRIBE foo.`items`;
DESCRIBE `items`;

The DESCRIBE query does not permit backticks to surround table names. The error returned is

FAILED: SemanticException [Error 10001]: Table not found `items`

Issue Links

• is related to: HIVE-2949 bug with describe and reserved keyword
• relates to: HIVE-6013 Supporting Quoted Identifiers in Column Names