FAILED: ParseException: cannot recognize input near 'exchange' 'string' ',' in column specification

Question

I am using latest AWS Hive version 0.13.0.

FAILED: ParseException: cannot recognize input near 'exchange' 'string' ',' in column specification

I am getting the above error when I run the below(create table) query.

CREATE EXTERNAL TABLE test ( 
foo string, 
exchange string,
bar string) ROW FORMAT DELIMITED
FIELDS TERMINATED BY '\t' 
LINES TERMINATED BY '\n' 
STORED AS TEXTFILE
LOCATION '/home/hadoop/test/';

If I rename the exchange like 'xch' it creates table successfully. Any reason?

Ashrith · Accepted Answer · 2015-01-12 10:15:50Z

3

You are getting an error because exchange is a keyword used to move the data in a partition from a table to another table that has the same schema but does not already have that partition for details view Hive Language Manual and HIVE-4095.

answered Jan 12, 2015 at 10:15

Ashrith

6,8652 gold badges33 silver badges38 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Amit Bhat · Accepted Answer · 2017-04-28 18:17:12Z

0

Try it like this after create statement LOAD DATA LOCAL INPATH '/home/cloudera/Amit/xyz.csv' OVERWRITE INTO TABLE tabele_name;

answered Apr 28, 2017 at 18:17

Amit Bhat

236 bronze badges

Collectives™ on Stack Overflow

FAILED: ParseException: cannot recognize input near 'exchange' 'string' ',' in column specification

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related