Quanlong Huang created HIVE-28912:
-------------------------------------
Summary: 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
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)
