Hive's meta data supports the following three types of storage, two of which are local storage and one for remote storage. Remote Storage is more suitable for production environments. Hive official Wiki Details these three ways, linked to: Hive Metastore.
First, local derby
This is the simplest way to store it, simply by making the following configuration in Hive-site.xml
[HTML] View plain copy print? <?xml version= "1.0"?> <?xml-stylesheet type= "text/xsl" Configuration.xsl "?> <configuration> <property> <name>javax.jdo.option.ConnectionURL</name> < Value>jdbc:derby:;d atabasename=metastore_db;create=true</value> </property> <property> <name> javax.jdo.option.connectiondrivername</name> <value> org.apache.derby.jdbc.embeddeddriver</value> </property> <property> <name>hive.metastore.local</name> <value>true</value> </property> <property> <name>hive.metastore.warehouse.dir</name> <value>/user/hive/warehouse</value> </property> <property> <name >hive.metastore.warehouse.dir</name> &nbs