suja s created RANGER-4702:
------------------------------
Summary: Confirmation regarding RF/ColMask on materialized views
Key: RANGER-4702
URL: https://issues.apache.org/jira/browse/RANGER-4702
Project: Ranger
Issue Type: Bug
Components: Ranger
Reporter: suja s
STEPS TO REPRODUCE:
Create a ranger hive policy for user u1 to access table t1, view v1 and
materialized view mv1.
Create table t1 and add data. Create view v1 and materialized view mv1.
Add a column masking policy for one of the columns of table t1
Try select data from t1, v1 and mv1
CURRENT BEHAVIOUR:
Select works for t1 and v1 and data is masked in results based on the enforced
column mask policy.
For materialized view, select is not allowed
Error: Error while compiling statement: FAILED: SemanticException [Error
10288]: Querying directly materialized view contents is not supported since we
detected db1.t1 used by materialized view has row masking/column filtering
enabled (state=42000,code=10288)
EXPECTED BEHAVIOUR:
Need confirmation on expected behaviour for materialized view
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
