[
https://issues.apache.org/jira/browse/HIVE-28912?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17945813#comment-17945813
]
Quanlong Huang commented on HIVE-28912:
---------------------------------------
ALLOC_WRITE_ID_EVENT are also missing catName:
{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" = 'ALLOC_WRITE_ID_EVENT' order by "EVENT_ID" desc limit 10;
EVENT_ID | EVENT_TIME | EVENT_TYPE | CAT_NAME |
DB_NAME | TBL_NAME
----------+------------+----------------------+----------+----------------------------------------------------+------------------
86358 | 1745043365 | ALLOC_WRITE_ID_EVENT | | events_test_db
| testnotifytable1
86350 | 1744962926 | ALLOC_WRITE_ID_EVENT | |
test_hms_event_sync_with_commit_compaction_1ac0b73 | foo
86345 | 1744962904 | ALLOC_WRITE_ID_EVENT | |
test_hms_event_sync_with_commit_compaction_1ac0b73 | foo
86323 | 1744962856 | ALLOC_WRITE_ID_EVENT | |
test_hms_event_sync_with_commit_compaction_1ac0b73 | foo
86318 | 1744962642 | ALLOC_WRITE_ID_EVENT | |
test_hms_event_sync_with_commit_compaction_1ac0b73 | foo
86296 | 1744962607 | ALLOC_WRITE_ID_EVENT | |
test_hms_event_sync_with_commit_compaction_1ac0b73 | foo
86291 | 1744962599 | ALLOC_WRITE_ID_EVENT | |
test_hms_event_sync_with_commit_compaction_1ac0b73 | foo
86269 | 1744962551 | ALLOC_WRITE_ID_EVENT | |
test_hms_event_sync_with_commit_compaction_1ac0b73 | foo
86264 | 1744962529 | ALLOC_WRITE_ID_EVENT | |
test_hms_event_sync_with_commit_compaction_1ac0b73 | foo
86242 | 1744962488 | ALLOC_WRITE_ID_EVENT | |
test_hms_event_sync_with_commit_compaction_1ac0b73 | foo
(10 rows){noformat}
> 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
> 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)
