创建外表失败


#1

使用自建用户os建表报错,错误如下:
SQL 错误 [1] [08S01]: EXECUTION FAILED: Task DDL error HiveException: [Error 1] Got exception: org.apache.hadoop.security.AccessControlException Permission denied: user=hive, access=WRITE, inode="/ext/ods":os:os:drwxr-xr-x
java.sql.SQLException: EXECUTION FAILED: Task DDL error HiveException: [Error 1] Got exception: org.apache.hadoop.security.AccessControlException Permission denied: user=hive, access=WRITE, inode="/ext/ods":os:os:drwxr-xr-x
EXECUTION FAILED: Task DDL error HiveException: [Error 1] Got exception: org.apache.hadoop.security.AccessControlException Permission denied: user=hive, access=WRITE, inode="/ext/ods":os:os:drwxr-xr-x


#2

您好,我也出现了同样的问题,请问您是怎么解决的呢


#4

这个错误很明显了,建外表的location指定的HDFS目录,就是这里的/etc/ods,需要给hive用户权限


在线支持