[ https://issues.apache.org/jira/browse/HIVE-6792?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13961210#comment-13961210 ]
Hive QA commented on HIVE-6792: ------------------------------- {color:green}Overall{color}: +1 all checks pass Here are the results of testing the latest attachment: https://issues.apache.org/jira/secure/attachment/12638621/HIVE-6792.1.patch {color:green}SUCCESS:{color} +1 5547 tests passed Test results: http://bigtop01.cloudera.org:8080/job/PreCommit-HIVE-Build/2129/testReport Console output: http://bigtop01.cloudera.org:8080/job/PreCommit-HIVE-Build/2129/console Messages: {noformat} Executing org.apache.hive.ptest.execution.PrepPhase Executing org.apache.hive.ptest.execution.ExecutionPhase Executing org.apache.hive.ptest.execution.ReportingPhase {noformat} This message is automatically generated. ATTACHMENT ID: 12638621 > 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.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)