We have configured HDP 126.96.36.199 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.
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>'