高可用hiveserver2

复制代码
<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<?xml-stylesheet type="text/xsl" href="configuration.xsl"?>
<configuration>
  <!-- 初步计划CDH2作为服务端,CDH1作为数据库,CDH3作为客户端-->
   <!--Hive作业的HDFS根目录位置 -->
   <property>
    <name>hive.exec.scratchdir</name>
    <value>/hive/data</value>
</property>
<!--Hive作业的HDFS根目录创建写权限 -->
<property>
    <name>hive.scratch.dir.permission</name>
    <value>777</value>
</property>
<!--hdfs上hive元数据存放位置,默认 -->
<property>
  <name>hive.metastore.warehouse.dir</name>
  <value>/hive/warehouse</value>
</property>
<!--元数据存放路径 -->
<property>
  <name>hive.metastore.uris</name>
  <value>thrift://cdh2:9083</value>
</property>
<!--客户端显示当前查询表的头信息 -->
 <property>
  <name>hive.cli.print.header</name>
  <value>true</value>
</property>
<!--客户端显示当前数据库名称信息 -->
<property>
  <name>hive.cli.print.current.db</name>
  <value>true</value>
</property>

<property>
  <name>hive.server2.support.dynamic.service.discovery</name>
  <value>true</value>
  </property>
   
  <property>
  <name>hive.server2.zookeeper.namespace</name>
  <value>hiveserver2_zk</value>
  </property>
   
  <property>
  <name>hive.zookeeper.quorum</name>
  <value> cdh1:2182,cdh2:2182,cdh3:2182</value>
  </property> 
  <property>
  <name>hive.zookeeper.client.port</name>
  <value>2182</value>
  </property> 
  <property>
  <name>hive.server2.thrift.bind.host</name>
  <value>0.0.0.0</value>
  </property> 
  <property>
  <name>hive.server2.thrift.port</name>
  <value>10001</value> 
  </property>

</configuration>
复制代码

--hive-site.xml

复制代码
--namenode节点启动
start-dfs.sh
--datanode节点启动
start-yarn.sh
--以上均在节点1启动
--节点2启动metastore
hive --service metastore -p 9083 &
--节点1启动hiveserver2
hiveserver2
--节点1启动beeline连接hive2
[root@cdh1 /]# beeline
SLF4J: Class path contains multiple SLF4J bindings.
SLF4J: Found binding in [jar:file:/home/hive/apache-hive-2.1.1-bin/lib/log4j-slf4j-impl-2.10.0.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in [jar:file:/home/hadoop-2.7.5/share/hadoop/common/lib/slf4j-log4j12-1.7.10.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation.
SLF4J: Actual binding is of type [org.apache.logging.slf4j.Log4jLoggerFactory]
Beeline version 3.1.2 by Apache Hive
beeline> !connect jdbc:hive2://cdh1:2182,cdh2:2182,cdh3:2182/;serviceDiscoveryMode=zooKeeper;zooKeeperNamespace=hiveserver2_zk root 147258
Connecting to jdbc:hive2://cdh1:2182,cdh2:2182,cdh3:2182/;serviceDiscoveryMode=zooKeeper;zooKeeperNamespace=hiveserver2_zk
22/09/15 16:50:12 [main]: INFO jdbc.HiveConnection: Connected to 0.0.0.0:10001
Connected to: Apache Hive (version 3.1.2)
Driver: Hive JDBC (version 3.1.2)
Transaction isolation: TRANSACTION_REPEATABLE_READ
0: jdbc:hive2://cdh1:2182,cdh2:2182,cdh3:2182> 
复制代码

ok

根据此方式部署后,先启动metastore再启动beeline(root 147258为账户名密码)

!connect jdbc:hive2://cdh1:2182,cdh2:2182,cdh3:2182/;serviceDiscoveryMode=zooKeeper;zooKeeperNamespace=hiveserver2_zk root 147258

 

posted @   M_Fight๑҉  阅读(2)  评论(0编辑  收藏  举报
相关博文:
阅读排行:
· 一个费力不讨好的项目,让我损失了近一半的绩效!
· 实操Deepseek接入个人知识库
· CSnakes vs Python.NET:高效嵌入与灵活互通的跨语言方案对比
· 【.NET】调用本地 Deepseek 模型
· Plotly.NET 一个为 .NET 打造的强大开源交互式图表库
历史上的今天:
2023-12-09 K8S-部署Kafka
点击右上角即可分享
微信分享提示