1.beeline直接連接:
beeline -u jdbc:hive2://192.168.188.100:10000 -n wind(用戶名)
2.beeline的參數化連接
hiveserver2_url="jdbc:hive2://192.168.188.100:10000 -n wind(用戶名)"
beeline -u ?${hiveserver2_url} -f /home/hadoop/app/shell/hive/ --hivevar v_data=value;
3.beeline的高可用性連接
beeline -u "jdbc:hive2://192.168.188.100:2181,192.168.188.101:2181,192.168.188.102:2181,192.168.188.103:2181/;serviceDiscoveryMode=zookeeper;zookeeperNmaespace=hiveserver2 ?-n wind(用戶名)"
4.beeline的有權限的高可用連接
beeline -u "jdbc:hive2://dn02.hadoop.cn:2181,dn01.hadoop.cn:2181,dn03.hadoop.cn:2181/devportaldemo;serviceDiscoveryMode=zooKeeper;zooKeeperNamespace=hiveserver2;auth=kerberos;principal=hive/dn04.hadoop.cn@HADOOP.CN?mapreduce.job.queuename=0122a8ed-08e0-4945-acb7-d04f910b196c"