[ https://issues.apache.org/jira/browse/HIVE-28912?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Sai Hemanth Gantasala reassigned HIVE-28912: -------------------------------------------- Assignee: Sai Hemanth Gantasala > CAT_NAME of COMMIT_COMPACTION_EVENT is always NULL > -------------------------------------------------- > > Key: HIVE-28912 > URL: https://issues.apache.org/jira/browse/HIVE-28912 > Project: Hive > Issue Type: Bug > Reporter: Quanlong Huang > Assignee: Sai Hemanth Gantasala > Priority: Critical > > Checked the events in "NOTIFICATION_LOG" table, the "CAT_NAME" column of > COMMIT_COMPACTION_EVENT are always NULL. > {noformat} > HMS_home_quanlong_workspace_Impala_cdp=> select "EVENT_ID", "EVENT_TIME", > "EVENT_TYPE", "CAT_NAME", "DB_NAME", "TBL_NAME" from "NOTIFICATION_LOG" where > "EVENT_TYPE" = 'COMMIT_COMPACTION_EVENT' order by "EVENT_ID" desc limit 10; > EVENT_ID | EVENT_TIME | EVENT_TYPE | CAT_NAME | > DB_NAME | TBL_NAME > ----------+------------+-------------------------+----------+----------------------------------------------------+--------------------------------- > 85555 | 1744954952 | COMMIT_COMPACTION_EVENT | | > test_hms_event_sync_with_commit_compaction_1ac0b73 | foo > 85528 | 1744954736 | COMMIT_COMPACTION_EVENT | | > test_hms_event_sync_with_commit_compaction_1ac0b73 | foo > 85501 | 1744948602 | COMMIT_COMPACTION_EVENT | | > test_hms_event_sync_with_commit_compaction_1ac0b73 | foo > 85474 | 1744948352 | COMMIT_COMPACTION_EVENT | | > test_commit_compaction_with_abort_txn_34731920 | part_table > 85445 | 1744948278 | COMMIT_COMPACTION_EVENT | | > test_commit_compaction_events_fdb340e1 | test_cc_table_unloaded > 85415 | 1744948246 | COMMIT_COMPACTION_EVENT | | > test_commit_compaction_events_fdb340e1 | > test_cc_partitioned_table_error > 85389 | 1744948220 | COMMIT_COMPACTION_EVENT | | > test_commit_compaction_events_fdb340e1 | test_cc_unpart_table > 85363 | 1744948195 | COMMIT_COMPACTION_EVENT | | > test_commit_compaction_events_fdb340e1 | test_cc_partitioned_table > 85321 | 1744947561 | COMMIT_COMPACTION_EVENT | | > test_hms_event_sync_txn_d2027724 | foo > 85009 | 1744947176 | COMMIT_COMPACTION_EVENT | | > test_hms_event_sync_txn_d2027724 | foo > (10 rows){noformat} > Other event types do have a valid CAT_NAME if they are db/table level events, > e.g. > {noformat} > HMS_home_quanlong_workspace_Impala_cdp=> select "EVENT_ID", "EVENT_TIME", > "EVENT_TYPE", "CAT_NAME", "DB_NAME", "TBL_NAME" from "NOTIFICATION_LOG" order > by "EVENT_ID" desc limit 10; > EVENT_ID | EVENT_TIME | EVENT_TYPE | CAT_NAME | > DB_NAME | TBL_NAME > ----------+------------+-------------------------+----------+----------------------------------------------------+---------- > 85559 | 1744955524 | DROP_DATABASE | hive | > test_hms_event_sync_with_commit_compaction_1ac0b73 | > 85558 | 1744955523 | CREATE_DATABASE | hive | > test_hms_event_sync_with_commit_compaction_1ac0b73 | > 85557 | 1744954956 | DROP_DATABASE | hive | > test_hms_event_sync_with_commit_compaction_1ac0b73 | > 85556 | 1744954956 | DROP_TABLE | hive | > test_hms_event_sync_with_commit_compaction_1ac0b73 | foo > 85555 | 1744954952 | COMMIT_COMPACTION_EVENT | | > test_hms_event_sync_with_commit_compaction_1ac0b73 | foo > 85554 | 1744954952 | COMMIT_TXN | | > | > 85553 | 1744954952 | COMMIT_TXN | | > | > 85552 | 1744954952 | OPEN_TXN | | > | > 85551 | 1744954952 | COMMIT_TXN | | > | > 85550 | 1744954952 | OPEN_TXN | | > | > (10 rows){noformat} > CC [~VenuReddy], [~hemanth619] -- This message was sent by Atlassian Jira (v8.20.10#820010)