[ https://issues.apache.org/jira/browse/HIVE-24533?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Gopal Vijayaraghavan updated HIVE-24533: ---------------------------------------- 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. {code} <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> {code} {code} standalone-metastore$ mvn clean install test -Dtest=MiniHMS -DminiHMS.run=true -Drat.skip=true {code} Copy the port off the logs and use it to run the metastore-benchmarks on mysql8. was: 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 and have a listener port. {code} <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> {code} {code} standalone-metastore$ mvn clean install test -Dtest=MiniHMS -DminiHMS.run=true -Drat.skip=true {code} Copy the port off the logs and use it to run the metastore-benchmarks on mysql8. > Metastore: Allow miniHMS to startup standalone > ---------------------------------------------- > > Key: HIVE-24533 > URL: https://issues.apache.org/jira/browse/HIVE-24533 > Project: Hive > Issue Type: Improvement > Components: Standalone Metastore > Affects Versions: 4.0.0 > Reporter: Gopal Vijayaraghavan > Assignee: Gopal Vijayaraghavan > Priority: Minor > Attachments: HIVE-24533.1.patch > > > 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. > {code} > <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> > {code} > {code} > standalone-metastore$ mvn clean install test -Dtest=MiniHMS > -DminiHMS.run=true -Drat.skip=true > {code} > Copy the port off the logs and use it to run the metastore-benchmarks on > mysql8. -- This message was sent by Atlassian Jira (v8.3.4#803005)