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