<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&characterEncoding=UTF-8& 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>
Start Thriftserver in spark after modification and then connect in beeline mode under Spark's Bin
or write a. sh file every time you execute it directly
. sh file contents such as:./beeline-u jdbc:hive2://yangsy132:10000/default-n root-p Yangsiyi
Spark on Hive configures Hive's metastore to MySQL