Support Questions

Find answers, ask questions, and share your expertise

unable to create TEMP TABLES in HIVE via HUE

Contributor

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
2 REPLIES 2

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

Contributor

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