Hive: HiveServer2

本文介绍HiveServer2的配置参数,包括Thrift接口的最小和最大工作线程数、异步执行线程池大小及超时时间等,并提供启动命令。HiveServer2支持远程客户端执行Hive查询并获取结果。

HiveServer2 (HS2) is a server interface that enables remote clients to execute queries against Hive and retrieve the results. The current implementation, based on Thrift RPC, is an improved version of HiveServer and supports multi-client concurrency and authentication. It is designed to provide better support for open API clients like JDBC and ODBC.

 

Configure

 <property>
  <name>hive.server2.thrift.min.worker.threads</name>
  <value>5</value>
  <description>Minimum number of Thrift worker threads</description>
</property>

<property>
  <name>hive.server2.thrift.max.worker.threads</name>
  <value>500</value>
  <description>Maximum number of Thrift worker threads</description>
</property>

<property>
  <name>hive.server2.async.exec.threads</name>
  <value>50</value>
  <description>Number of threads in the async thread pool for HiveServer2</description>
</property>

<property>
  <name>hive.server2.async.exec.shutdown.timeout</name>
  <value>10</value>
  <description>Time (in seconds) for which HiveServer2 shutdown will wait for async
  threads to terminate</description>
</property>

<property>
  <name>hive.server2.thrift.port</name>
  <value>10000</value>
  <description>Port number of HiveServer2 Thrift interface.
  Can be overridden by setting $HIVE_SERVER2_THRIFT_PORT</description>
</property>

<property>
  <name>hive.server2.thrift.bind.host</name>
  <value>192.168.122.1</value>
  <description>Bind host on which to run the HiveServer2 Thrift interface.
  Can be overridden by setting $HIVE_SERVER2_THRIFT_BIND_HOST</description>
</property>

-----

<property>
  <name>hive.server2.transport.mode</name>
  <value>binary</value>
  <description>Server transport mode. "binary" or "http".</description>
</property>

<property>
  <name>hive.server2.thrift.http.port</name>
  <value>10001</value>
  <description>Port number when in HTTP mode.</description>
</property>

<property>
  <name>hive.server2.thrift.http.path</name>
  <value>cliservice</value>
  <description>Path component of URL endpoint when in HTTP mode.</description>
</property>

<property>
  <name>hive.server2.thrift.http.min.worker.threads</name>
  <value>5</value>
  <description>Minimum number of worker threads when in HTTP mode.</description>
</property>

<property>
  <name>hive.server2.thrift.http.max.worker.threads</name>
  <value>500</value>
  <description>Maximum number of worker threads when in HTTP mode.</description>
</property>

Start

$HIVE_HOME/bin/hiveserver2

$HIVE_HOME/bin/hive --service hiveserver2

$HIVE_HOME/bin/hive --service hiveserver2 -H

 

 

 

 

References:

https://cwiki.apache.org/confluence/display/Hive/Setting+up+HiveServer2

评论
成就一亿技术人!
拼手气红包6.0元
还能输入1000个字符
 
红包 添加红包
表情包 插入表情
 条评论被折叠 查看
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值