[HIVE-5407] show create table creating unusable DDL when some reserved keywords exist

• Type: Bug
• Status: Resolved
• Priority: Minor
• Resolution: Fixed
• Fix Version/s: 0.13.0
• Component/s: CLI

Environment

hive 0.11

• Assignee: Zhichun Wu
• Reporter: Zhichun Wu
• Created: 01/Oct/13 04:57
• Updated: 09/Oct/13 04:05
• Resolved: 08/Oct/13 15:32

Description

HIVE-701 already makes most reserved keywords available for table/column/partition names and 'show create table' produces usable DDLs.
However I think it's better if we quote table/column/partition names for the output of 'show create table', which is how mysql works and seems more robust.

For example, use select as column name will produce unusable DDL:

create table table_select(`select` string);
show create table table_select;