Smruti Biswal created HIVE-28242:
------------------------------------
Summary: Using SEQUENCE instead of NOTIFICATION_SEQUENCE table
Key: HIVE-28242
URL: https://issues.apache.org/jira/browse/HIVE-28242
Project: Hive
Issue Type: Improvement
Components: Hive
Affects Versions: 4.0.0
Reporter: Smruti Biswal
NOTIFICATION_SEQUENCE table currently holds 1 record and is accessed by Hive
using select for update. Will it be better to use a sequence instead?
This is because sequences can cache values in memory for each session and
reduce the number of changes in the background table (as well as the frequency
of related locking and serialization).
refer https://mariadb.com/kb/en/sequence-overview/
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
