Hive installation with MYSQL Metastore

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

  1. http://hueie.blogspot.co.uk/2017/04/hive-211-installation-using-embedded.
  2. http://www.myhadoopexamples.com/2015/06/26/steps-to-change-hadoop-hive-default-metastore-derby-db-to-mysql-db

    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

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

 

Leave a Reply

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