Created 02-11-2016 12:49 PM
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.
Created 02-11-2016 12:54 PM
Please check hive meta store settings in ambari and make sure that it's MySQL
Created 02-11-2016 12:54 PM
Please check hive meta store settings in ambari and make sure that it's MySQL
Created 02-11-2016 12:59 PM
How to check it? Which file to check?
Created 02-11-2016 01:01 PM
It's in ambari console
Created on 02-11-2016 01:10 PM - edited 08-19-2019 01:44 AM
Ambari shows MySQL is being used. Attaching the screenshot.
Created 02-11-2016 01:15 PM
For OOZIE we have selected New Derby Database. But for Hive we selected New MySQL db.
Created 02-11-2016 02:06 PM
Hi......any suggestions please?
Created 02-11-2016 03:11 PM
Created 02-11-2016 02:27 PM
Hi Guys...looking for your help. We cannot connect to Hive post set up because of the issue.
Created 02-12-2016 01:56 PM
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>'