Hive
  1. Hive
  2. HIVE-2013

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

    Details

    • Type: Improvement Improvement
    • Status: Open
    • Priority: Major Major
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None

      Description

      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.

        Activity

        Hide
        Ning Zhang added a comment -

        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.

        Show
        Ning Zhang added a comment - 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.

          People

          • Assignee:
            Unassigned
            Reporter:
            Ning Zhang
          • Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

            • Created:
              Updated:

              Development