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
Rising Star

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
Super 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
Super Mentor

@rajdip chaudhuri

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

avatar
Rising Star

How to check it? Which file to check?

avatar
Super Mentor

@rajdip chaudhuri

It's in ambari console

avatar
Rising Star

Ambari shows MySQL is being used. Attaching the screenshot.

2034-hive-metastore-issue.jpg

avatar
Rising Star

For OOZIE we have selected New Derby Database. But for Hive we selected New MySQL db.

avatar
Rising Star

Hi......any suggestions please?

avatar
Super Mentor

@rajdip chaudhuri

In Hive server

cd /var/log/hive/

and read logs to troubleshoot further

avatar
Rising Star

Hi Guys...looking for your help. We cannot connect to Hive post set up because of the issue.

avatar
Guru

Can you check mysql connectivity and past logs here. Can you also paste output of the following command.

SHOW GRANTS FOR 'hive';

And as Neeraj suggested please grant all privileges to hive user on host like below commend.

GRANT ALL PRIVILEGES ON *.* TO 'hive'@'<hive_host>' IDENTIFIED BY PASSWORD '<password>'