错误提示信息
[2020-09-23 18:07:58] )sql> create table order_partition ( order_no string, order_time string ) PARTITIONED BY (event_time string) row format delimited fields terminated by '\t'[2020-09-23 18:10:34] [08S01][1] Error while processing statement: 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=NONE, access=WRITE, inode="/user/hive/warehouse/order_partition":root:supergroup:drwxr-xr-x
错误场景
hive创建分区表
错误原因猜测
可能是我hive账号是 NONE, 没有这个权限,
解决办法
添加hdfs-site.xml 里面配置
/root/soft/hadoop-2.7.2/etc/hadoop/hdfs-site.xml
<property>
<name>dfs.permissionsname>
<value>falsevalue>
property>
重启Hadoop
去hadoop-2.7.2/sbin目录下面
重启NameNode和 DataNode
[root@zjj101 sbin]stopping namenode[root@zjj101 sbin]starting namenode, logging to /root/soft/hadoop-2.7.2/logs/hadoop-root-namenode-zjj101.out[root@zjj101 sbin]stopping datanode[root@zjj101 sbin]starting datanode, logging to /root/soft/hadoop-2.7.2/logs/hadoop-root-datanode-zjj101.out[root@zjj101 sbin]
Original: https://blog.51cto.com/u_14861909/5439571
Author: wx5efd5423d18bb
Title: hive创建分区表报错AccessControlException Permission denied: user=NONE, access=WRITE, inode
原创文章受到原创版权保护。转载请注明出处:https://www.johngo689.com/516804/
转载文章受原作者版权保护。转载请注明原作者出处!