- 需求描述:
由于业务需要,需要在css租户下创建一个新的数据库:css - 操作步骤:
[root@hadoop-e04 ~]# su - hadoop
[hadoop@hadoop-e04 ~]$ hive
#建库
hive (default)> create database css;
#赋权
hive (default)> grant ALL on database css_pe to user css;
- 报错记录
1、在创建数据库的时候出现报错:Authorization failed:No privilege ‘Create’ found for outputs { }. Use SHOW GRANT to get more details.
处理方案:
#关闭身份认证功能
hive (default)> set hive.security.authorization.enabled=flase;
2、在css用户创建表的时候报错:FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. MetaException(message:Got exception: org.apache.hadoop.security.AccessControlException Permission denied: user=ai_css, access=WRITE, inode="/user/hive/warehouse/css.db":hadoop:hadoop:drwxr-xr-x
处理方案:
#在hadoop用户下执行
hadoop dfs -ls /user/hive/warehouse/css.db
#修改文件的权限
hsdoop fs -chown -R css:hadoop /user/hive/warehouse/css.db
hsdoop fs -chmod -R 775 /user/hive/warehouse/css.db