One Star

Error while creating table via tHIVEROW

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'"
2 REPLIES
One Star

Re: Error while creating table via tHIVEROW

One Star

Re: Error while creating table via tHIVEROW

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