[ https://issues.apache.org/jira/browse/HIVE-26847?focusedWorklogId=833789&page=com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel#worklog-833789 ]
ASF GitHub Bot logged work on HIVE-26847: ----------------------------------------- Author: ASF GitHub Bot Created on: 15/Dec/22 12:14 Start Date: 15/Dec/22 12:14 Worklog Time Spent: 10m Work Description: kasakrisz commented on code in PR #3856: URL: https://github.com/apache/hive/pull/3856#discussion_r1049566428 ########## standalone-metastore/metastore-common/src/main/java/org/apache/hadoop/hive/metastore/conf/MetastoreConf.java: ########## @@ -1127,6 +1127,8 @@ public enum ConfVars { "command should handle partition retention. If enabled, and if a specific partition's age exceeded\n" + "retention period the partition will be dropped along with data"), + MATERIALIZED_VIEW_ENABLED("metastore.materialized.view.enabled", "metastore.materialized.view.enabled", true, Review Comment: > They always need to touch the file system when they have a query to make a log entry who touched what and when. MV creation is technically a table creation with some extra metadata. The same API is called and each time a table/mv is created a new entry is inserted into the `NOTIFICATION_LOG` table: In this example `emp` is a table `mv1` is a materialized view. ``` NL_ID|EVENT_ID|EVENT_TIME|EVENT_TYPE |CAT_NAME|DB_NAME |TBL_NAME 304| 303|1671096468|ALLOC_WRITE_ID_EVENT | |default |emp 305| 304|1671096468|ALTER_TABLE |hive |default |emp 306| 308|1671096472|CREATE_TABLE |hive |default |mv1 ``` Could this be used for audit? Issue Time Tracking ------------------- Worklog Id: (was: 833789) Time Spent: 2h 10m (was: 2h) > Allow a config to disable creation of Materialized Views > -------------------------------------------------------- > > Key: HIVE-26847 > URL: https://issues.apache.org/jira/browse/HIVE-26847 > Project: Hive > Issue Type: Improvement > Reporter: Ayush Saxena > Assignee: Ayush Saxena > Priority: Major > Labels: pull-request-available > Time Spent: 2h 10m > Remaining Estimate: 0h > -- This message was sent by Atlassian Jira (v8.20.10#820010)