[ https://issues.apache.org/jira/browse/HIVE-6792?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Chaoyu Tang updated HIVE-6792: ------------------------------ Attachment: HIVE-6792-1.patch Thanks, Szehon, for pointing out. I changed to use member variable conf instead and please see attached HIVE-6792-1.patch > 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 > Attachments: HIVE-6792-1.patch, HIVE-6792.patch > > > 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)