Sai Hemanth Gantasala created HIVE-29119:
--------------------------------------------
Summary: Create primary key/index for DELEGATION_TOKENS table in
oracle DB.
Key: HIVE-29119
URL: https://issues.apache.org/jira/browse/HIVE-29119
Project: Hive
Issue Type: Improvement
Components: Standalone Metastore
Reporter: Sai Hemanth Gantasala
Assignee: Sai Hemanth Gantasala
For Oracle DB, DELEGATION_TOKENS is missing a primary key/index, whereas it is
present for MySQL DB. Not having a primary key/index can be a bottleneck (if
the delegation token is stored in the DB, i.e, MemoryTokenStore) during restart
or when the connection count is too high.
Below is the table definition in Oracle:
{code:java}
CREATE TABLE DELEGATION_TOKENS
(
TOKEN_IDENT VARCHAR2(767) NOT NULL,
TOKEN VARCHAR2(767) NULL
); {code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
