Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

Hive metastore issue in HDp2.3.4.0

avatar
Expert Contributor

We have configured HDP 2.3.4.0 with Ambari in CentOS 6.4. Post installation we can see that the Hive Metastore service is getting stopped everytime it is started through Ambari. We had chosen MySQL for Hive metastore but in logs we can see it tries to connect with Derby. Looking for your help.

1 ACCEPTED SOLUTION

avatar
Master Mentor

@rajdip chaudhuri

Please check hive meta store settings in ambari and make sure that it's MySQL

View solution in original post

12 REPLIES 12

avatar
Master Mentor
@rajdip chaudhuri

Also, very important

Run following in mysql as root user

grant all privileges on *.* to 'hive'@'host' identified by 'hivepassword' with grant option;

avatar
Master Mentor

avatar
Master Mentor

@rajdip chaudhuri

Please go through the 2 attached install step by step methods it will help you resolve your problem

Please and let me know if all goes well