HIVE: Authorization failed:No privilege 'Select' found for inputs

bug: Authorization failed:No privilege 'Select' found for inputs

本图上set system:user.name=hadoop为错误标注, 不必理会

Hadoop环境: CDH 5.11

出现bug环境: linux 当前用户 dev, 执行的hive cli

解决方式: 修改当前用户的select权限, 如果遇到create的问题, 可用: GRANT CREATE ON DATABASE[TABLE]   DATABASE_NAME[TABLE_NAME]  TO USER USER_NAME 解决

eg: grant select on database jd to user dev; 针对数据库

      grant select on table jd.order to user dev; 针对表

参考文档: 

https://blog.csdn.net/TXBSW/article/details/78872942

https://blog.csdn.net/py_123456/article/details/80430244

https://www.cnblogs.com/superpang/p/4639145.html(这个为set 的使用, 如用不到set,只需参考上面2个地址)