查询远程hiveserver2没有响应

2024-06-24 13:41:29 发布

您现在位置:Python中文网/ 问答频道 /正文

我有这个hive-site.xml,它的属性由setting-up-hiveserver2添加

<?xml version="1.0"?>
<?xml-stylesheet type="text/xsl" href="configuration.xsl"?>
<configuration>
        <property>
          <name>javax.jdo.option.ConnectionURL</name>
          <value>jdbc:mysql://192.168.0.25:3306/hive_test?characterEncoding=UTF-8</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>123123</value>
        </property>
        <property>
          <name>datanucleus.fixedDatastore</name>
          <value>false</value>
        </property>
        <property>
          <name>hive.metastore.warehouse.dir</name>
          <value>/data/hive</value>
        </property>
        <property>
          <name>hive.exec.scratchdir</name>
          <value>/data/temp</value>
        </property>
        <property>
          <name>datanucleus.fixedDatastore</name>
          <value>false</value>
        </property>

        <property>
          <name>hive.querylog.location</name>
          <value>/home/hadoop/hadoopLogs/hive</value>
        </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>cloud1</value>
        </property>
        <property>
          <name>hive.server2.transport.mode</name>
          <value>binary</value>
        </property>

        <property>
        <name>hive.server2.authentication</name>
        <value>NOSASL</value>
        </property>
</configuration>

这是使用pyhs2的python代码

^{pr2}$

但是,当我运行这个python脚本时,hiverserver2控制台或python客户机没有任何变化。在

你能帮帮我吗。在


Tags: namevaluemysqlpropertyxmlthriftconfigurationoption