You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Ning Zhang (JIRA)" <ji...@apache.org> on 2011/02/28 23:32:36 UTC

[jira] Created: (HIVE-2013) Add a parameter in the Partition object to indicate it's privilege is the same as table level privilege

Add a parameter in the Partition object to indicate it's privilege is the same as table level privilege
-------------------------------------------------------------------------------------------------------

                 Key: HIVE-2013
                 URL: https://issues.apache.org/jira/browse/HIVE-2013
             Project: Hive
          Issue Type: Improvement
            Reporter: Ning Zhang
            Assignee: He Yongqiang


If a query involves many partitions, checking privilege for each partition could be very expensive. An optimization is to indicate in the partition metadata that its privilege is the same as table level (default) privilege so that we only do 1 ACL checking for the set of partitions having the default privilege. 

-- 
This message is automatically generated by JIRA.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

[jira] Commented: (HIVE-2013) Add a parameter in the Partition object to indicate it's privilege is the same as table level privilege

Posted by "Ning Zhang (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/HIVE-2013?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13000585#comment-13000585 ] 

Ning Zhang commented on HIVE-2013:
----------------------------------

One caveat for this approach is that when the table-level privilege is changed, all partitions have to be checked and reset the property appropriately. 

Assume changing table-level privilege is rare and querying tables whose partitions have different privileges is common, this optimization makes sense in most use cases. 

> Add a parameter in the Partition object to indicate it's privilege is the same as table level privilege
> -------------------------------------------------------------------------------------------------------
>
>                 Key: HIVE-2013
>                 URL: https://issues.apache.org/jira/browse/HIVE-2013
>             Project: Hive
>          Issue Type: Improvement
>            Reporter: Ning Zhang
>            Assignee: He Yongqiang
>
> If a query involves many partitions, checking privilege for each partition could be very expensive. An optimization is to indicate in the partition metadata that its privilege is the same as table level (default) privilege so that we only do 1 ACL checking for the set of partitions having the default privilege. 

-- 
This message is automatically generated by JIRA.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

[jira] [Assigned] (HIVE-2013) Add a parameter in the Partition object to indicate it's privilege is the same as table level privilege

Posted by "He Yongqiang (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/HIVE-2013?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

He Yongqiang reassigned HIVE-2013:
----------------------------------

    Assignee:     (was: He Yongqiang)

> Add a parameter in the Partition object to indicate it's privilege is the same as table level privilege
> -------------------------------------------------------------------------------------------------------
>
>                 Key: HIVE-2013
>                 URL: https://issues.apache.org/jira/browse/HIVE-2013
>             Project: Hive
>          Issue Type: Improvement
>            Reporter: Ning Zhang
>
> If a query involves many partitions, checking privilege for each partition could be very expensive. An optimization is to indicate in the partition metadata that its privilege is the same as table level (default) privilege so that we only do 1 ACL checking for the set of partitions having the default privilege. 

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira