You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Chaoyu Tang (JIRA)" <ji...@apache.org> on 2014/03/31 03:05:14 UTC

[jira] [Created] (HIVE-6792) hive.warehouse.subdir.inherit.perms doesn't work correctly in CTAS

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)