Hive installation with MYSQL Metastore

Hive deafult metastore is Derby, but I wanted to change it to mysql . I followed dollowing two links


    I was not able to start the hive shell and was getting following error

Exception in thread “main” java.lang.RuntimeException: org.apache.hadoop.hive.ql.metadata.HiveException: java.lang.RuntimeException: Unable to instantiate org.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClient

This was caused by

Caused by: MetaException(message:Version information not found in metastore)

To Resolve : Add following property in hive-site.xml

<name> hive.metastore.schema.verification</name>
It worked at last 🙂 …happy me


Leave a Reply

Your email address will not be published. Required fields are marked *