Uploaded image for project: 'Ranger'
  1. Ranger
  2. RANGER-4702

Confirmation regarding RF/ColMask on materialized views

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Open
    • Major
    • Resolution: Unresolved
    • None
    • None
    • Ranger
    • None

    Description

      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

      Attachments

        Activity

          People

            Unassigned Unassigned
            suja suja s
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated: