./beeline -u jdbc:hive2://hadoop03:10000 -n root -p root
不用每次都跟-u ,可以编辑beeline修改
. "$bin"/hive --service beeline "$@"
为:
. "$bin"/hive --service beeline -u jdbc:hive2://hadoop03:10000 "$@"
保存以后,每次直接输入beeline即可接入jdbc:hive2://hadoop03:10000>.
这样进去是一个匿名用户anonymous, 可以跟上-n 用户名 -p密码,指定用户连接.
启动beeline前需要启动hiveservice2进程: nohup ./hiveservice2 & 后台运行.
关于hiveservice2的一些配置,在hive-site.xml中添加:
<property>
<name>hive.server2.thrift.bind.host</name>
<value>hadoop03</value>
<description>Bind host on which to run the HiveServer2 Thrift service.</description>
</property>
<property>
<name>hive.server2.thrift.port</name>
<value>10000</value>
<description>Port number of HiveServer2 Thrift interface when hive.server2.transport.mode is 'binary'.</description>
</property>
<property>
<name>hive.server2.thrift.http.port</name>
<value>10001</value>
<description>Port number of HiveServer2 Thrift interface when hive.server2.transport.mode is 'http'.</description>
</property>
如果有权限限制的问题,hive启动beeline连接报错: User: xxx is not allowed to impersonate anonymous (state=08S01,code=0)
解决方式:在hadoop的配置文件core-site.xml增加如下配置,重启hdfs,其中“xxx”是连接beeline的用户,将“xxx”替换成自己的用户名即可
<property>
<name>hadoop.proxyuser.xxx.hosts</name>
<value>*</value>
</property>
<property>
<name>hadoop.proxyuser.xxx.groups</name>
<value>*</value>
</property>
hive启动beeline连接报错,来至https://www.jianshu.com/p/9ee7fc231854