spark on hive 配置hive的metastore為mysql

標籤：

<property>
<name>hive.metastore.uris</name>
<value></value>
<description>Thrift uri for the remote metastore. Used by metastore client to connect to remote metastore.</description>
</property>

<property>
<name>javax.jdo.option.ConnectionURL</name>
<value>jdbc:mysql://localhost:3306/mysql?useUnicode=true&amp;characterEncoding=UTF-8&amp;createDatabaseIfNotExist=true</value>
</property>

<property>
<name>javax.jdo.option.ConnectionDriverName</name>
<value>com.mysql.jdbc.Driver</value>
<description>Driver class name for a JDBC metastore</description>
</property>

<property>
<name>javax.jdo.option.ConnectionUserName</name>
<value>root</value>
<description>username to use against metastore database</description>
</property>

<property>
<name>javax.jdo.option.ConnectionPassword</name>
<value>yangsiyi</value>
<description>password to use against metastore database</description>
</property>

 

 

修改完後 在spark中啟動thriftserver，隨後在spark的bin下 用beeline方式串連

或者寫成一個.sh檔案 每次直接執行即可

.sh檔案內容如：./beeline -u jdbc:hive2://yangsy132:10000/default -n root -p yangsiyi

spark on hive 配置hive的metastore為mysql