[
https://issues.apache.org/jira/browse/HIVE-20336?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16573990#comment-16573990
]
Jesus Camacho Rodriguez edited comment on HIVE-20336 at 8/8/18 10:40 PM:
-------------------------------------------------------------------------
Current solution:
- Materialized views are materialized without taking into account policies
defined on source tables.
- If a user queries the source tables used by a materialized view, the policies
are applied as usual (if defined). This may result in triggering a rewriting
using a materialized view but filtering/masking after reading contents from the
materialized view.
- Policies on a materialized view cannot be defined and will not be enforced.
- For any given user, if a materialized view uses source tables that are
masked/filtered through policies, then the user cannot query the materialized
view directly (e.g., {{SELECT * FROM mv}}). We throw an error.
Cc [~ashutoshc]
was (Author: jcamachorodriguez):
Current solution:
- Materialized views are materialized without taking into account policies
defined on source tables.
- If a user queries the source tables used by a materialized view, the policies
are applied as usual (if defined). This may result in triggering a rewriting
using a materialized view but filtering/masking after reading contents from the
materialized view.
- Policies on a materialized view cannot be defined and will not be enforced.
- For any given user, if a materialized view uses source tables that are
masked/filtered through policies, then the user cannot query the materialized
view directly (e.g., {{SELECT * FROM mv}}). We throw an error.
> Masking and filtering policies for materialized views
> -----------------------------------------------------
>
> Key: HIVE-20336
> URL: https://issues.apache.org/jira/browse/HIVE-20336
> Project: Hive
> Issue Type: Bug
> Components: Authorization, Materialized views
> Reporter: Jesus Camacho Rodriguez
> Assignee: Jesus Camacho Rodriguez
> Priority: Major
> Attachments: HIVE-20336.patch
>
>
> Implement masking and filtering policies for materialized views.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
