配置Hive高可用by zk:
http://community.cloudera.com/t5/Batch-SQL-Apache-Hive/CDH-5-4-0-and-HiveServer2-High-Availability-via-ZooKeeper/td-p/33469
http://lxw1234.com/archives/2016/05/675.htm
1、open hive -> Configuration -> Category -> Advanced
2、find "HiveServer2 Advanced Configuration Snippet (Safety Valve) for hive-site.xml"
3、write:
<property>
<name>hive.server2.support.dynamic.service.discovery</name>
<value>true</value>
</property>
4、config namespace
<property>
<name>hive.server2.zookeeper.namespace</name>
<value>hiveserver2</value>
</property>
5、restart and hiveserver2 is register to zookeeper.
follow lxw!
6、连接
[testuser@testhost ~]$ beeline
Beeline version 1.1.0-cdh5.14.0 by Apache Hive
beeline> !connect jdbc:hive2://zknode1:2181,zknode22181/default;serviceDiscoveryMode=zooKeeper;zooKeeperNamespace=hiveserver2 testuser ''
scan complete in 2ms
Connecting to jdbc:hive2://zknode1:2181,zknode2:2181/default;serviceDiscoveryMode=zooKeeper;zooKeeperNamespace=hiveserver2
18/05/03 10:38:19 [main]: INFO jdbc.HiveConnection: Connected to zknode1:10000
Connected to: Apache Hive (version 1.1.0-cdh5.14.0)
Driver: Hive JDBC (version 1.1.0-cdh5.14.0)
Transaction isolation: TRANSACTION_REPEATABLE_READ
0: jdbc:hive2://zknode1:2181,zk-web>
权限配置
http://www.cnblogs.com/yurunmiao/p/4449439.html
性能调优:
hive on tez: http://lxw1234.com/archives/2017/06/860.htm
hive on spark : https://www.cloudera.com/documentation/enterprise/latest/topics/admin_hos_oview.html
http://cwiki.apachecn.org/pages/viewpage.action?pageId=2888665