当前位置: 代码迷 >> 综合 >> hive创建分区表报错AccessControlException Permission denied: user=NONE, access=WRITE, inode
  详细解决方案

hive创建分区表报错AccessControlException Permission denied: user=NONE, access=WRITE, inode

热度:32   发布时间:2024-02-21 19:11:48.0

错误提示信息

[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.permissions</name><value>false</value>
</property>

重启Hadoop

去hadoop-2.7.2/sbin目录下面
重启NameNode和 DataNode


[root@zjj101 sbin]# hadoop-daemon.sh stop namenode
stopping namenode
[root@zjj101 sbin]# hadoop-daemon.sh start namenode
starting namenode, logging to /root/soft/hadoop-2.7.2/logs/hadoop-root-namenode-zjj101.out
[root@zjj101 sbin]# hadoop-daemon.sh stop datanode
stopping datanode
[root@zjj101 sbin]# hadoop-daemon.sh start datanode
starting datanode, logging to /root/soft/hadoop-2.7.2/logs/hadoop-root-datanode-zjj101.out
[root@zjj101 sbin]# 
  相关解决方案