Reply
Explorer
Posts: 18
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
Cloudera Employee
Posts: 425
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?
Highlighted
Explorer
Posts: 18
Registered: ‎10-04-2017

Re: unable to create TEMP TABLES in HIVE via HUE

figured out there are locks on user temp tables, cleared locks and able to drop them. Thanks 

Announcements