[HIVE-6058] Creating Table with column name exchange gives exception

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Done
• Affects Version/s: 0.12.0
• Component/s: Query Processor

Environment

Hadoop 2.0.1-beta, Hive 0.12 , running hiveserver , Installed on CentOS6.4 64-bit OS in Multinode configuration

• Assignee: Unassigned
• Reporter: Anilkumar Kalshetti
• Created: 19/Dec/13 12:43
• Updated: 23/Nov/17 05:03
• Resolved: 12/Feb/15 09:33

Description

1. Create Table using below script
CREATE TABLE test_column_name2 ( c1 string) ROW FORMAT DELIMITED STORED AS SEQUENCEFILE;

2. Table is created successfully.
Now Create another Table with column name exchange
by using below script

CREATE TABLE test_column_name ( exchange string) ROW FORMAT DELIMITED STORED AS SEQUENCEFILE;

3. This gives exception for column name exchange, for Hive 0.12
4. The script properly works for Hive 0.11