Exception in thread main java lang RuntimeException Hive metastore database is not initialized

Question

Hi everyone.

I am tring to enter in hive shell. But I am Getting the below error.

 ERROR StatusLogger No log4j2 configuration file found. Using default configuration: logging only errors to the console.

    Exception in thread "main" java.lang.RuntimeException: Hive metastore database is not initialized. Please use schematool (e.g. ./schematool -initSchema -dbType ...) to create the schema. If needed, don't forget to include the option to auto-create the underlying database in your JDBC connection string (e.g. ?createDatabaseIfNotExist=true for mysql)

Can anyone tell me, what I am doing wrong?

Thank You

Answer 1

Hi@akhtar,

In this scenario, first you check if the metastore service is running or not and then try the below command.

$ schematool -dbType derby -initSchema

Hope this will solve your error.
Thank You