Clever Geek Handbook

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

I am using the latest AWS Hive 0.13.0 .

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

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

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 the table successfully. Any reason?

+3


source to share


2 answers


You receive an error message because it exchange

is a keyword used to move data in a section from a table to another table with the same schema but not yet having this section to view the Hive Language Guide and HIVE-4095 information .



+2


source


Try this after creating a LOAD DATA LOCAL INPATH '/home/cloudera/Amit/xyz.csv' OVERWRITE INTO TABLE tabele_name;



0


source






More articles:


All Articles