Taraka Rama Rao Lethavadla created HIVE-26898: -------------------------------------------------
Summary: Split Notification logging so that we can busy clusters can have better performance Key: HIVE-26898 URL: https://issues.apache.org/jira/browse/HIVE-26898 Project: Hive Issue Type: New Feature Reporter: Taraka Rama Rao Lethavadla For DDL & DML events are logged into notifications log table and those get cleaned as soon as ttl got expired. In most of the busy clusters, the notification log is growing even though cleaner is running and kept on cleaning the events. It means the rate of Hive db operations are very high compared to rate at which cleaning is happening. So any query on this table is becoming bottle neck at backend DB causing slow response The proposal is to split the notification log table in to multiple tables like notification_log_dml - for all DML queries notification_log_insert - for all insert queries .. etc. So that load on that single table gets reduced improving the performance of the backend db as well as Hive -- This message was sent by Atlassian Jira (v8.20.10#820010)