Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

unable to create TEMP TABLES in HIVE via HUE

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

Re: unable to create TEMP TABLES in HIVE via HUE

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

Re: unable to create TEMP TABLES in HIVE via HUE

Contributor

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