hive3.1.1 hive-site.xml

<property>  
  <name>hive.metastore.warehouse.dir</name>  
  <value>/data/hive/warehouse</value>  
</property>  
   
<property>  
  <name>hive.metastore.local</name>  
  <value>false</value>  
</property>  
<property>  
  <name>hive.metastore.schema.verification</name>  
   <value>false</value>  
</property> 

<property>
    <name>javax.jdo.option.ConnectionURL</name>
    <value>jdbc:mysql://node06/hive_remote?createDatabaseIfNotExist=true</value>
</property>
<property>
    <name>javax.jdo.option.ConnectionDriverName</name>
    <value>com.mysql.jdbc.Driver</value>
</property>
<property>
    <name>javax.jdo.option.ConnectionUserName</name>
    <value>root</value>
</property>
<property>
    <name>javax.jdo.option.ConnectionPassword</name>
    <value>123</value>
</property>