[
https://issues.apache.org/jira/browse/HIVE-28912?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Zhihua Deng updated HIVE-28912:
-------------------------------
Component/s: Standalone Metastore
> 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
> Components: Standalone Metastore
> Reporter: Quanlong Huang
> Assignee: Sai Hemanth Gantasala
> Priority: Critical
> Fix For: 4.1.0
>
>
> 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)
