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'"
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
