+1 vote
in Hive by

Wherever (Different Directory) I run the hive query, it creates new metastore_db, please explain the reason for it?

1 Answer

0 votes
by

Basically, it creates the local metastore, while we run the hive in embedded mode. Also, it looks whether metastore already exist or not before creating the metastore. Hence, in configuration file hive-site.xml. Property is “javax.jdo.option.ConnectionURL” with default value “jdbc:derby:;databaseName=metastore_db;create=true” this property is defined. Hence, to change the behavior change the location to the absolute path, thus metastore will be used from that location.

Related questions

+1 vote
asked Jan 12, 2020 in Big Data | Hadoop by sharadyadav1986
+1 vote
asked Dec 3, 2020 in Hive by sharadyadav1986
...