文章目录
一、准备
1.1 安装环境
[root@master ~]# cat /etc/redhat-release
CentOS Linux release 7.3.1611 (Core)
1.2 依赖服务
mysql5.7:https://blog.csdn.net/qq_39680564/article/details/84943471
hadoop-3.0.3:https://blog.csdn.net/qq_39680564/article/details/89513162
Hbase2.1.0:https://blog.csdn.net/qq_39680564/article/details/89515459
Hive3.1.1:https://blog.csdn.net/qq_39680564/article/details/89714184
二、修改配置文件
修改hadoop 配置文件hdfs-site.xml(如果集群的话每个都要修改)
添加如下内容:
<property>
<name>dfs.webhdfs.enabled</name>
<value>true</value>
</property>
修改hadoop 配置文件core-site.xml(如果集群的话每个都要修改)
添加如下内容:
<property>
<name>hadoop.proxyuser.hadoop.hosts</name>
<value>*</value>
</property>
<property>
<name>hadoop.proxyuser.hadoop.groups</name>
<value>*</value>
</property>
<property>
<name>hadoop.proxyuser.root.hosts</name>
<value>*</value>
</property>
<property>
<name>hadoop.proxyuser.root.groups</name>
<value>*</value>
</property>
重启hadoop
三、hiveServer2启动
直接启动
[root@master ~]# hiveserver2
启动成功
2019-05-08 11:46:56: Starting HiveServer2
SLF4J: Class path contains multiple SLF4J bindings.
SLF4J: Found binding in [jar:file:/opt/hive-3.1.1/lib/log4j-slf4j-impl-2.10.0.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in [jar:file:/opt/hadoop-3.0.3/share/hadoop/common/lib/slf4j-log4j12-1.7.25.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]
Hive Session ID = 3dd5a4c1-3030-4d43-9ec1-53bd1561ebb9
后台启动
nohup hiveserver2 1>/root/hiveserver.log 2>/root/hiveserver.err &
或
nohup hiveserver2 > hive.log 2>&1 &
四、beeline连接
启用beeline连接
[root@master ~]# beeline
SLF4J: Class path contains multiple SLF4J bindings.
SLF4J: Found binding in [jar:file:/opt/hive-3.1.1/lib/log4j-slf4j-impl-2.10.0.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in [jar:file:/opt/hadoop-3.0.3/share/hadoop/common/lib/slf4j-log4j12-1.7.25.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.1 by Apache Hive
连接hive库
beeline> !connect jdbc:hive2://master:10000
Connecting to jdbc:hive2://master:10000
Connected to: Apache Hive (version 3.1.1)
Driver: Hive JDBC (version 3.1.1)
Transaction isolation: TRANSACTION_REPEATABLE_READ
0: jdbc:hive2://master:10000>
master是我的hadoop主机映射名
10000为默认端口
查看hive库中的表
0: jdbc:hive2://master:10000> show tables;
+-----------------+
| tab_name |
+-----------------+
| hbase_table_1 |
| hbase_table_2 |
| hbase_table_21 |
| hbase_table_3 |
+-----------------+
4 rows selected (0.124 seconds)
五、dbeaver连接
下载dbeaver:https://download.csdn.net/download/qq_39680564/11166519
5.1 新建hive连接
5.2 填入连接信息
只需要填写hadoop的主机IP,端口默认10000
5.3 编辑连接驱动
删掉自带的驱动,添加与hive版本匹配的驱动,该驱动可以在hive的jdbc目录下找到
5.4 测试连接
连接成功(beeline可以连接,使用dbeaver不会出现什么异常)
5.5 查看hive库的表
六、报错分析
报错一:
User root is not allowed to impersonate anonymous 错误
解决:
https://www.cnblogs.com/rocky-AGE-24/p/6925129.html