1、报错
Error: Could not open client transport with JDBC Uri: jdbc:hive2://node1:10000: Failed to open new session: java.lang.RuntimeException: org.apache.hadoop.ipc.RemoteException(org.apache.hadoop.security.authorize.AuthorizationException): User: root is not allowed to impersonate hive (state=08S01,code=0)
问题原因
root用户没有权限,在hdfs配置中添加相应用户即可
解决
添加hdfs参数:
vim core-site.xml
<property>
<name>hadoop.proxyuser.root.groups</name>
<value>*</value>
</property>
<property>
<name>hadoop.proxyuser.root.hosts</name>
<value>*</value>
</property>
2、报错
FAILED: SemanticException [Error 10072]: Database does not exist
解决
#原因是mysql的连接超时时间太短
#修改mysql配置文件,在MySQL配置文件my.ini/my.cnf中添加或修改
#最大连接数
max_connections=1000
#设置超时时间,超过设置时间没有请求就主动断开,单位是秒
wait_timeout = 600
interactive_timeout = 600
3、报错
hive创建权限后无法建库的问题(Authorization failed:No privilege 'Create' found for outputs { }. Use SHOW GRANT to get more details)
解决
#进入管理账号hive命令行里执行
#给账号work所有权限
grant all to user work;