[jira] [Created] (HIVE-24140) Improve materialized view authorization check

["Vineet Garg (Jira)" <ji...@apache.org>]

Vineet Garg created HIVE-24140:
----------------------------------

             Summary: Improve materialized view authorization check
                 Key: HIVE-24140
                 URL: https://issues.apache.org/jira/browse/HIVE-24140
             Project: Hive
          Issue Type: Improvement
          Components: Query Planning
            Reporter: Vineet Garg


Currently (with HIVE-23454) after mv rewriting authorization check on each mv is done and rewrite is rejected if check of any mv fails.
This is inefficient as it does authorization check after rewriting. Ideally this check should be done prior to rewrite (and skip rewrite accordingly).

One approach is to check for all mv for tables involved in the query (This may cause rewrite to skip even though mv may not be select for rewrite)
Another approach is to cache mv privileges in the registry and refresh them periodically.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)