Error Unable to instantiate org.apache.hadoop.hive.metastore.HiveMetaStoreClient - while trying to create database

Karthig
New Contributor III

Hello All,

I get the org.apache.spark.sql.AnalysisException: org.apache.hadoop.hive.ql.metadata.HiveException: java.lang.RuntimeException: Unable to instantiate org.apache.hadoop.hive.metastore.HiveMetaStoreClient while trying to create a database

scripts used

%sql

USE hive_metastore;

CREATE DATABASE XYZ;

%sql

CREATE DATABASE XYZ;

%sql

CREATE DATABASE hive_metastore.XYZ;

the warehouse seems to be in started state

imageimage.png 

Cluster details

image