You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Xuefu Zhang (JIRA)" <ji...@apache.org> on 2013/12/19 19:06:08 UTC
[jira] [Commented] (HIVE-6058) Creating Table with column name
exchange gives exception
[ https://issues.apache.org/jira/browse/HIVE-6058?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13853082#comment-13853082 ]
Xuefu Zhang commented on HIVE-6058:
-----------------------------------
"exchange" became a reserved keyword in hive, so the error is expected.
> Creating Table with column name exchange gives exception
> ------------------------------------------------------------
>
> Key: HIVE-6058
> URL: https://issues.apache.org/jira/browse/HIVE-6058
> Project: Hive
> Issue Type: Bug
> Components: Query Processor
> Affects Versions: 0.12.0
> Environment: Hadoop 2.0.1-beta, Hive 0.12 , running hiveserver , Installed on CentOS6.4 64-bit OS in Multinode configuration
> Reporter: Anilkumar Kalshetti
> Attachments: table_columnname_exchange_exception.png
>
>
> 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
--
This message was sent by Atlassian JIRA
(v6.1.4#6159)