Q&A
Ask and answer questions to make information more available to wider audiences.
Justin Gaffney
@justin_gaffney 14, Jun 2023 12:00 AM
run a Hive query
Whenever we run a Hive query, a new metastore_db is created. Why?
answers 2
Answer 1
Jose Grimsbro
@josegrimsbro 21, Jun 2023 12:33 PM
The property is:
javax.jdo.option.ConnectionURL
with the default value:
jdbc:derby:;databaseName=metastore_db;create=true
Therefore, we have to change the behavior of the location to an absolute path so that from that location the metastore can be used.
Answer 2
Jose Grimsbro
@josegrimsbro 21, Jun 2023 12:33 PM
A local metastore is created when we run Hive in an embedded mode. Before creating, it checks whether the metastore exists or not, and this metastore property is defined in the configuration file, hive-site.xml.