[
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)
