1

I am trying to set up metastore for Hive but getting error saying:

"Hive metastore is not initialized"

I tried it with derby and mysql but I am getting the same error for both the database.

Cœur
  • 37,241
  • 25
  • 195
  • 267
Vidhi
  • 11
  • 2
  • maybe check out the answers in http://stackoverflow.com/questions/35655306/hive-installation-issues-hive-metastore-database-is-not-initialized – Jared Apr 01 '16 at 13:57
  • Hi I already tried all the solutions provided in stackover flow and other sites but none of them works for me. Do you have an other solution ? – Vidhi Apr 02 '16 at 09:14
  • hi do you have another trick to solve this problem or could you please provide me any better link to re install the hive on my machine ? – Vidhi Apr 04 '16 at 06:03

1 Answers1

1

For a mysql databasem you first have to create a userhive and a metastore database. You then have to initialize the metastore thought the below command:

$HIVE_HOME/bin/schematool  -dbType mysql  -initSchema

This will initialize the schema.

more detail on that tutorial

parisni
  • 920
  • 7
  • 20