Principal [] does not have following privileges for operation CREATETABLE [[OBJECT OWNERSHIP]

赋予所有权限ALL并没有用

hive> create role new_dw_role;

hive> grant all on database ods to role new_dw_role;

hive> grant role new_dw_role to user edw;

hive> show grant role new_dw_role on all;

hive> show roles;

hive> show role grant user edw;

hive> show grant user edw on all;

hive> show grant user edw on database ods;
# 上面是通过先赋权限给角色，角色再给用户，下面是直接赋给用户
hive> grant all on database ods to user edw;

hive> show grant user edw on database ods;

hive> show grant on database ods;

缺少的是 OBJECT OWNERSHIP，还需要更改所有者

alter database ods set owner user edw;
# 也可给多个用户，赋予权限
alter database ods set owner role tmp_role;

还要赋予hdfs目录相应权限

hdfs dfs -chmod 777 /user/hive/warehouse/ods.db