Failed to create database in hive

Question

I'm using Hive with mysql. Creating database in mysql worked. Somehow could not create database in Hive. The error shows SemanticException like below. Is there anything that I missed? I've tried a few suggested solutions but still couldn't fix it.

Try hive --service metastore

pvy4917
– pvy4917

2018-10-31 16:10:39 +00:00
Commented Oct 31, 2018 at 16:10 — pvy4917
– pvy4917, Commented Oct 31, 2018 at 16:10

Nishu Tayal · Accepted Answer · 2018-10-31 22:03:42Z

2

It seems, the hive metastore service is not started. After you configure the meta store in hive-site.xml, start the service with below command.

hive --service metastore

answered Oct 31, 2018 at 22:03

Nishu Tayal

20.9k8 gold badges53 silver badges105 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

gdphy · Accepted Answer · 2018-11-12 10:12:10Z

0

I solved this issue by initialising hive metastore database

$HIVE_HOME/bin/schematool -initSchema -dbType $databaseType

answered Nov 12, 2018 at 10:12

gdphy

911 gold badge2 silver badges13 bronze badges

Collectives™ on Stack Overflow

Failed to create database in hive

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related