Hello Everyone, I need some help with below workaround. This is regarding hive table(ACID transactional) where i want to copy data from PROD to PRE_PROD. 1. How to move the data from the source ACID table to a non-ACID table. 2. How to move the data from non-ACID table to ACID table. Please suggest me with the commands as i am struggling to get it from many days. Many thanks in advance!!! ... View more

Hi Team, As we know that the Hortonworks has resumed the certification exam and now we have HDPCA 2.6.x and HDPCA 3.x available. So what is the difference between both the certification version? Is there any change in the exam pattern? Any changes in the syllabus? Any prons and cons? Please let me know as i am preparing for the certification. Thanking in Advance!!! ... View more

Hi All, I am facing one issue with the Hbase archive directory where i see the following directory /apps/hbase/data/archive size is increasing daily. This is basically started to happen post we took snapshot for 4 tables. Can someone help me to understand why the archive directory size started to increase daily post we took the snapshot? What is causing this directory to increase the size? What is the recommendation and solutions for this? Hbase version: 1.1.2.2.5 Thanking in Advance!!! ... View more

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!!! hive-logs.txt ... View more

Hello Everyone, Need help to find the command I have two cluster - ClusterA and ClusterB I want to connect to hive server of clusterB from ClusterA Can anyone help with the proper command I tried few commands but that did not help me. Request you to help me to figure out the command Regards, Shrikant ... View more

Hi Team, I have come across one of the strange issue in our cluster where i see that suddenly all of the services turns out to be Yellow and says that heartbeat lost of that particular services. It seems to be intermittent the services sometimes turns to green and after sometime it again turns out to be yellow and says that heartbeat lost. Ambari Version: Version2.4.2.0 Ambari -Agent version: ambari-agent-2.4.2.0-136 Please find the screenshot attached.heartbeat-lost.png We have tried restarting ambari-server, ambari-agent, postgresql but did not help. We have checked the logs but did not find anything. Can anyone please help me in providing the solution to get this fixed? Also would like to know what made to arise this issue suddenly? Thanking in Advance..!! ... View more

Hi Team, we have configured all the Ambari alerts to send a notification to an email id's till today. Now we are in plan to integrate the Ambari to Service Now(any ITSM) so that there is an incident open in servicenow. Please let me know if this is possible to do? If Yes then please send me some articles/Links to refer and I can plan accordingly. Also let me know if there any challenges that we might come across. Thanking in Advance.. ... View more