[IMPALA-3297] --insert_inherit_permissions option has no effect on INSERT OVERWRITE

• Type: Bug
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Affects Version/s: Impala 2.0
• Component/s: Frontend
• Labels: security
• Assignee: Unassigned
• Reporter: Skye Wanderman-Milne
• Created: 05/Apr/16 00:05
• Updated: 15/Mar/17 17:50

Description

From http://community.cloudera.com/t5/Interactive-Short-cycle-SQL/insert-inherit-permissions-has-no-effect-on-quot-insert/m-p/39270#M1612, it appears that --insert_inherit_permissions is not observed when doing an INSERT OVERWRITE:

Came across an interesting behavior with insert_inherit_permissions param.

Doing a bunch of "insert into" table x, hdfs file persmissions are as expected as shown below.

drwxrwxrwt - impala hive 0 2015-01-06 10:39 /user/hive/warehouse/rt_test/year=2015/month=1/adate=6/hour=10/min=39

Then I did an "insert overwrite" on the same table and found that the hdfs file persmissions got reset as shown below:

drwxr-xr-x - impala hive 0 2015-01-06 10:43 /user/hive/warehouse/rt_test/year=2015/month=1/adate=6/hour=10/min=39

I am on impala 2.0....
Is this a bug?

Issue Links

• is duplicated by: IMPALA-3363 Error using insert_inherit_permissions