Chaoyu Tang created HIVE-6792:
---------------------------------
Summary: hive.warehouse.subdir.inherit.perms doesn't work
correctly in CTAS
Key: HIVE-6792
URL: https://issues.apache.org/jira/browse/HIVE-6792
Project: Hive
Issue Type: Bug
Components: Authorization, Security
Affects Versions: 0.14.0
Reporter: Chaoyu Tang
Assignee: Chaoyu Tang
hive.warehouse.subdir.inherit.perms doesn't work correctly in CTAS. When it is
set to true, the table created using create table .. as select.. does not
inherit its parent directory's group and permission mode. It can be easily
reproduced:
==
hive> dfs -ls -R /user/hive/warehouse;
drwxrwx--T - hive hive 0 2014-03-30 17:44
/user/hive/warehouse/ctas.db
drwxr-xr-x - hive hive 0 2014-03-30 17:20
/user/hive/warehouse/ctas_src_tbl
-rw-r--r-- 3 hive hive 46059 2014-03-30 17:20
/user/hive/warehouse/ctas_src_tbl/000000_0
hive> create table ctas.test_perm as select * from ctas_src_tbl;
hive> dfs -ls -R /user/hive/warehouse;
drwxrwx--T - hive hive 0 2014-03-30 17:46
/user/hive/warehouse/ctas.db
drwxr-xr-x - hive supergroup 0 2014-03-30 17:46
/user/hive/warehouse/ctas.db/test_perm
-rw-r--r-- 3 hive supergroup 46059 2014-03-30 17:46
/user/hive/warehouse/ctas.db/test_perm/000000_0
drwxr-xr-x - hive hive 0 2014-03-30 17:20
/user/hive/warehouse/ctas_src_tbl
-rw-r--r-- 3 hive hive 46059 2014-03-30 17:20
/user/hive/warehouse/ctas_src_tbl/000000_0
==
The created table does not inherit its database ctas's group hive and
permission mode 770, instead it takes the default group (supergroup) and
permission mode (755) in hdfs
--
This message was sent by Atlassian JIRA
(v6.2#6252)
