topic Error while creating table via tHIVEROW in Talend Studio

Error while creating table via tHIVEROW

_AnonymousUser — Sat, 16 Nov 2024 10:47:41 GMT

Hi,
I am getting the following error while executing the talend hive-load job
"Error while compiling statement: FAILED: ParseException line 2:2 cannot recognize input near 'exchange' 'STRING' ',' in column specificationError while compiling statement"
My hive query is as follows: please let me know what is the issue with my query
"create table if not exists NYSE_daily_price
(exchange STRING,
stock_symbol STRING,
stock_date DATE,
stock_price_open FLOAT,
stock_price_high FLOAT,
stock_price_low FLOAT,
stock_volume INT,
stock_avg_price_close FLOAT)
row format delimited
fields terminated BY ';'
location '/user/cloudera/talendfilesnew/NYSE_daily_price'"

Re: Error while creating table via tHIVEROW

Anonymous — Thu, 18 Feb 2016 13:09:43 GMT

I came across a post in stackoverflow.com that may help you:
http://stackoverflow.com/questions/27899049/failed-parseexception-cannot-recognize-input-near-exchange-string-in-c

Re: Error while creating table via tHIVEROW

_AnonymousUser — Sat, 20 Feb 2016 21:41:48 GMT

Hi asadri, Thank you for the solution. I changed the column name it is working. But I am getting another error when querying the table
How you do you fix this error? please help me.

Error while compiling statement: FAILED: SemanticException Unable to determine if hdfs://192.168.421.10:8020/user/cloudera/talendfilesnew/stocks is encrypted: java.lang.IllegalArgumentException: Wrong FS: hdfs://192.168.421.10:8020/user/cloudera/talendfilesnew/stocks, expected: hdfs://quickstart.cloudera:8020