hive客户端访问Hadoop数据，hive-site如何配置呢？

Question

我目前配置为这个样子，win7 ODBC 一直访问不了，昨天突然成功了，重启了下电脑又不行了，不知道问题到底在哪里，希望大神给予指点

<?xml version="1.0" encoding="UTF-8" standalone="no"?>

<?xml-stylesheet type="text/xsl" href="configuration.xsl"?>

<configuration>

<property>  

     <name>hive.hwi.war.file</name>  

     <value>lib/hive-hwi-0.12.0-SNAPSHOT.war</value>  

     <description>This sets the path to the HWI war file, relative to ${HIVE_HOME}. </description>  

</property> 

 

<property>  

    <name>hive.hwi.listen.host</name>  

    <value>192.168.111.150</value>  

    <description>This is the host address the Hive Web Interface will listen on</description>  

</property> 

 

 <property>  

    <name>hive.hwi.listen.port</name>  

    <value>9999</value>  

    <description>This is the port the Hive Web Interface will listen on</description>  

 </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.ConnectionURL</name>

    <value>jdbc:mysql://192.168.111.164:3306/hive?characterEncoding=UTF-8</value>

    <description>JDBC connect string 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>root</value>

    <description>password to use against metastore database</description>

</property>

<property>

    <name>hive.server2.thrift.min.worker.threads</name>

    <value>5</value>

</property>

<property>

    <name>hive.server2.thrift.max.worker.threads</name>

    <value>500</value>

</property>

<property>

    <name>hive.server2.thrift.port</name>

    <value>10000</value>

</property>

<property>

    <name>hive.server2.thrift.bind.host</name>

    <value>192.168.111.150</value>

</property>

<property>

    <name>hive.server2.transport.mode</name>

    <value>HTTP</value>

</property>

<property>

    <name>hive.server2.thrift.http.port</name>

    <value>10001</value>

</property>

<property>

    <name>hive.server2.thrift.http.path</name>

    <value>cliservice</value>

</property>

<property>

    <name>hive.server2.thrift.http.min.worker.threads</name>

    <value>5</value>

</property>

<property>

    <name>hive.server2.thrift.http.max.worker.threads</name>

    <value>500</value>

</property>

</configuration>