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:54:14 UTC

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

     [ 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.patch

Please review attached patch. With this, the new created table (test_perm) with its data file inherit group and permission mode from their parent cats.db.
==
hive> dfs -ls -R /user/hive/warehouse;                          
drwxrwx--T   - hive   hive                0 2014-03-30 17:56 /user/hive/warehouse/ctas.db
drwxrwx--T   - hive   hive                0 2014-03-30 17:56 /user/hive/warehouse/ctas.db/test_perm
-rw-rw----   3 hive   hive            46059 2014-03-30 17:56 /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

> 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.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)