Reply
Explorer
Posts: 15
Registered: ‎10-04-2017

unable to create TEMP TABLES in HIVE via HUE

when I am trying to create a TEMP table  getting below error 

 

drop table app_fwa.tmpsettime;
select * from app_fwa.tmpsettime;
create temporary table app_fwa.tmpsettime AS SELECT from_unixtime(unix_timestamp()) as vartime;

 
Error while processing statement: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.mr.MapRedTask
Highlighted
Cloudera Employee
Posts: 400
Registered: ‎03-23-2015

Re: unable to create TEMP TABLES in HIVE via HUE

Looks like MR job failed, have you checked the yarn application logs to see what the actual error was?
Announcements