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)