Support Questions
Find answers, ask questions, and share your expertise

Error starting HIVE metastore

Re: Error starting HIVE metastore

Rising Star

@Harry Li

Try following:

create user 'hive'@'msl-dpe-perf74.msl.lab' identified by 'hive';
grant all privileges on *.* to 'hive'@'msl-dpe-perf74.msl.lab';
SHOW GRANTS FOR 'hive'@'msl-dpe-perf74.msl.lab';
flush privileges;
commit;
quit;

Set the password of 'hive'@'msl-dpe-perf74.msl.lab' same as what you have given via Ambari.

Other thing I could see from the error you mentioned in the beginning on this post was :

org.apache.hadoop.hive.metastore.HiveMetaException:Failed to get schema version

Can you check if following works for you:

/usr/hdp/current/hive/bin/schematool -initSchema -dbType  mysql
Highlighted

Re: Error starting HIVE metastore

Rising Star
/usr/hdp/current/hive/bin/schematool -info -dbType mysql -userName hive -passWord <password> -verbose

Try following command and share the output.