You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "Jesus Camacho Rodriguez (JIRA)" <ji...@apache.org> on 2018/08/08 22:41:00 UTC
[jira] [Comment Edited] (HIVE-20336) Masking and filtering policies
for materialized views
[ 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)