使用DBeaver链接Hive

1.Hive开启Hivemetastore和HiveServer2

nohup /opt/module/hive3.1.2/bin/hive --service metastore >$HIVE_LOG_DIR/metastore.log 2>&1 &
nohup /opt/module/hive3.1.2/bin/hive --service hiveserver2 >$HIVE_LOG_DIR/hiveServer2.log 2>&1 &

2.配置链接的用户名和密码

vim conf/hive-site.xml

  hive.server2.thrift.client.user
  lytfly
  Username to use against thrift client


  hive.server2.thrift.client.password
  199000
  Password to use against thrift client

确保添加的用户lytfly对HDFS文件系统/tmp/hive有权限，否会报以下错误：

java.lang.RuntimeException: Error applying authorization policy on hive configuration: The dir: /tmp/hive on HDFS should be writable. Current permissions are: rwx------

解决方案：https://my.oschina.net/liuyuantao/blog/5276881

在beeline进行连接时，如果出现以下问题

Error: Could not open client transport with JDBC Uri: jdbc:hive2://node101:10000/default: Failed to open new session: java.lang.RuntimeException: org.apache.hadoop.ipc.eption(org.apache.hadoop.security.authorize.AuthorizationException): User: lytfly is not allowed to impersonate lytfly (state=08S01,code=0)

这是因为在hadoop的core-site.xml缺少了以下配置：

	hadoop.proxyuser.lytfly.groups
	*


	hadoop.proxyuser.lytfly.hosts
	*

重启Hadoop集群，重启Hive的Hivemetastore和HiveServer2即可。