Created 07-30-2018 11:25 AM
Hi Team,
I am finding below error while executing the below hive query. This query is sent through java code.
CREATE TEMPORARY TABLE SACC_MASTER.CC_ASSETS_TS AS SELECT * FROM (SELECT ASSET_ID,SHIPD_DTS_GMT,CNTRCT_END_DTS_GMT,ACCNT_ID,ACCNT_NAME,PROD_LOB,PROD_TYPE,PROD_LINE,WARRANTY_CODE,WARRANTY_DESC,ACTIVE_FLG,ENRICHED_FLG,VALIDATE_FLG,SUPPORT_ASSIST_FLG,GROUP_ID,GROUP_NAME,SITE_ID,SITE_NAME,RGN_ABBR,RGN_DESC,SACC_LAST_UPDATED, RANK() OVER (PARTITION BY ASSET_ID ORDER BY SACC_LAST_UPDATED DESC) AS RANK FROM SACC_HISTORY.ASSETS_HISTORY ) RANKED WHERE RANKED.RANK=1 AND RANKED.ACCNT_ID IN (6083)
ERROR
7-30 05:13:29 [HLrjsXi62P] ERROR o.d.p.s.c.f.HiveOptimizedConnector -Exception executing DDL Statement java.sql.SQLException: Error while processing statement: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.tez.TezTask at org.apache.hive.jdbc.HiveStatement.execute(HiveStatement.java:275)
7-30 05:13:29 [HLrjsXi62P] ERROR o.d.p.s.c.p.ReportDataController -**ERROR**: Exception while fetching report templates from distributions table or preparing hive staging table. java.lang.Exception: java.lang.Exception: java.sql.SQLException: Error while processing statement: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.tez.TezTask at org.abc.pprc.standalone.ccreports.persist.ReportGeneratorDBStore.fetchAndUpdateDistributionsTable(ReportGeneratorDBStore.java:130)
by: java.lang.Exception: java.sql.SQLException: Error while processing statement: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.tez.TezTask
I have attached the detailed logs file. please suggest with solutions
Thanking in Advance!!!
Created 08-01-2018 06:31 PM
Hi !
Could you please share the RM Application_xxxx_xxx logs for this?
Created 08-01-2018 08:06 PM
Can you provide output of the explain and explain formatted:
explain CREATE TEMPORARY TABLE SACC_MASTER.CC_ASSETS_TS AS SELECT * FROM (SELECT ASSET_ID,SHIPD_DTS_GMT,CNTRCT_END_DTS_GMT,ACCNT_ID,ACCNT_NAME,PROD_LOB,PROD_TYPE,PROD_LINE,WARRANTY_CODE,WARRANTY_DESC,ACTIVE_FLG,ENRICHED_FLG,VALIDATE_FLG,SUPPORT_ASSIST_FLG,GROUP_ID,GROUP_NAME,SITE_ID,SITE_NAME,RGN_ABBR,RGN_DESC,SACC_LAST_UPDATED, RANK() OVER (PARTITION BY ASSET_ID ORDER BY SACC_LAST_UPDATED DESC) AS RANK FROM SACC_HISTORY.ASSETS_HISTORY ) RANKED WHERE RANKED.RANK=1 AND RANKED.ACCNT_ID IN (6083);
Can you try to change the execution engine to MR and run the same query?
Provide the output of following:
describe SACC_MASTER;
describe CC_ASSETS_TS;
Also the hive-logs.txt appear to the client logs.
Can you upload the hiveserver2.log file ?