[ 
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)

Reply via email to