Reply
New Contributor
Posts: 8
Registered: ‎09-28-2018

The Hive Metastore canary failed to create a database.

[ Edited ]

Hive is being run on Name Node 1.

When I start Hive service everything is green and up and running:

Hive Metastore Server
HiveServer2

WebHCat Server

After few minutes Hive Metastore Server becomes unavailable with bad health:

Hive Metastore Canary 

"The Hive Metastore canary failed to create a database."

 

Few more information:

  • we do not have any MySQL database, we are using OOTB configuration for Hive, so it is probably Postgre
  • I already run command Update Hive Metastore Database Schema and Update Hive Metastore Name Nodes after installation. They are grey now.

 

Please advise for further steps.

Thank you

 

Announcements