By default, hive runs with embedded derby metastore, which allows only one connection. This article is about how to hive with derby network server. Assume hive is installed to /opt/hive folder

1. Download derby https://db.apache.org/derby/derby_downloads.html to /opt/derby folder
2. Start derby server nohup /opt/derby/bin/startNetworkServer &
3. Edit /opt/hive/conf/hive-site.xml
   
   <property> <name>javax.jdo.option.ConnectionURL</name> <value>jdbc:derby://localhost:1527/metastore_db;create=true</value> </property> <property> <name>javax.jdo.option.ConnectionDriverName</name> <value>org.apache.derby.jdbc.ClientDriver</value> <description>Driver class name for a JDBC metastore. EmbeddedDriver or ClientDriver</description> </property>

   1 2 3 4 5 6 7 8 9

   <property>     <name>javax.jdo.option.ConnectionURL</name>     <value>jdbc:derby://localhost:1527/metastore_db;create=true</value> </property> <property>     <name>javax.jdo.option.ConnectionDriverName</name>     <value>org.apache.derby.jdbc.ClientDriver</value>     <description>Driver class name for a JDBC metastore. EmbeddedDriver or ClientDriver</description> </property>

4. Start derby
   
   nohup /opt/derby/bin/startNetworkServer &

   1	nohup /opt/derby/bin/startNetworkServer &

5. Init metastore
   
   /opt/hive/bin/schematool -initSchema -dbType derby

   1	/opt/hive/bin/schematool -initSchema -dbType derby

6. Start hiveserver2 and beeline, should work both simultaneously
   
   nohup /opt/hive/bin/hiveserver2 &

   1	nohup /opt/hive/bin/hiveserver2 &

   
   and check in browser http://localhost:10002
   
   /opt/hive/bin/beeline -u jdbc:hive2://localhost:10000

   1	/opt/hive/bin/beeline -u jdbc:hive2://localhost:10000