[HIVE-24533] Metastore: Allow miniHMS to startup standalone

• Type: Improvement
• Status: Patch Available
• Priority: Minor
• Resolution: Unresolved
• Affects Version/s: 4.0.0
• Component/s: Standalone Metastore
• Assignee: Gopal Vijayaraghavan
• Reporter: Gopal Vijayaraghavan
• Created: 14/Dec/20 19:47
• Updated: 15/Dec/20 00:43

Description

Similar to how StartMiniHS2Cluster works.

https://github.com/apache/hive/blob/master/itests/hive-unit/src/test/java/org/apache/hive/jdbc/miniHS2/StartMiniHS2Cluster.java

I had to add the following to the metastore-site.xml to connect to a localhost mysql8 (& add mysql jdbc driver as a test dep) and have a listener thrift endpoint.

<property><name>javax.jdo.option.ConnectionURL</name><value>jdbc:mysql://localhost:3306/hive</value></property>
<property><name>javax.jdo.option.ConnectionDriverName</name><value>com.mysql.cj.jdbc.driver</value></property>
<property><name>javax.jdo.option.ConnectionUserName</name><value>hive</value></property>
<property><name>javax.jdo.option.ConnectionPassword</name><value>hive</value></property>
<property><name>datanucleus.connectionPool.maxPoolSize</name><value>4</value></property>
<property><name>metastore.warehouse.dir</name><value>file:///tmp/hms/warehouse</value></property>
<property><name>metastore.metastore.event.db.notification.api.auth</name><value>false</value></property>

standalone-metastore$ mvn clean install test -Dtest=MiniHMS  -DminiHMS.run=true -Drat.skip=true  

Copy the port off the logs and use it to run the metastore-benchmarks on mysql8.