Hello @Ram B, you need to set your new password in the hive metastore also. You can make it through Ambari UI: Login to the Ambari Dashboard --> click on hive --> Configs --> then Advanced -->under Hive Metastore section --> change the password (your root new password) --> then restart All. Now hive should be working with no problems. ... View more

Hello @Xianshun Chen, thanks a lot. Your answer helped me. May I ask you how did you found your solution? ... View more