question Re: Hive metastore issue in HDp2.3.4.0 in Support Questions

Hive metastore issue in HDp2.3.4.0

rajdip_chaudhur — Thu, 11 Feb 2016 20:49:40 GMT

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.

Re: Hive metastore issue in HDp2.3.4.0

nsabharwal — Thu, 11 Feb 2016 20:54:26 GMT

@rajdip chaudhuri

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

Re: Hive metastore issue in HDp2.3.4.0

rajdip_chaudhur — Thu, 11 Feb 2016 20:59:07 GMT

How to check it? Which file to check?

Re: Hive metastore issue in HDp2.3.4.0

nsabharwal — Thu, 11 Feb 2016 21:01:59 GMT

@rajdip chaudhuri

It's in ambari console

Re: Hive metastore issue in HDp2.3.4.0

rajdip_chaudhur — Mon, 19 Aug 2019 08:44:17 GMT

Ambari shows MySQL is being used. Attaching the screenshot.

Re: Hive metastore issue in HDp2.3.4.0

rajdip_chaudhur — Thu, 11 Feb 2016 21:15:29 GMT

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

Re: Hive metastore issue in HDp2.3.4.0

rajdip_chaudhur — Thu, 11 Feb 2016 22:06:45 GMT

Hi......any suggestions please?

Re: Hive metastore issue in HDp2.3.4.0

rajdip_chaudhur — Thu, 11 Feb 2016 22:27:15 GMT

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

Re: Hive metastore issue in HDp2.3.4.0

nsabharwal — Thu, 11 Feb 2016 23:11:27 GMT

@rajdip chaudhuri

In Hive server

cd /var/log/hive/

and read logs to troubleshoot further

Re: Hive metastore issue in HDp2.3.4.0

nsabharwal — Thu, 11 Feb 2016 23:18:16 GMT

@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;

Re: Hive metastore issue in HDp2.3.4.0

Shelton — Thu, 11 Feb 2016 23:35:12 GMT

@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

Re: Hive metastore issue in HDp2.3.4.0

SK1 — Fri, 12 Feb 2016 21:56:29 GMT

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>'

Re: Hive metastore issue in HDp2.3.4.0

nsabharwal — Mon, 15 Feb 2016 20:56:18 GMT

@rajdip chaudhuri