Details
-
Bug
-
Status: Resolved
-
Critical
-
Resolution: Fixed
-
Impala 2.1
-
None
-
None
Description
After enabling HDFS synchronization with Sentry and set proper acl permission.
hdfs dfs -getfacl /user/hive/warehouse
- file: /user/hive/warehouse
- owner: hive
- group: hive
user::rwx
user:hive:rwx
group::---
group:hive:rwx
group:daisuke:rwx
mask::rwx
other::--x
all insert queries to those tables fails.
insert into movie2 select 1;
Query: insert into movie2 select 1
ERROR: AnalysisException: Unable to INSERT into target table (default.movie2) because Impala does not have WRITE access to at least one HDFS path: hdfs://dice.lab.cloudera.com:8020/user/hive/warehouse/movie2