[
https://issues.apache.org/jira/browse/HIVE-29119?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Sai Hemanth Gantasala resolved HIVE-29119.
------------------------------------------
Fix Version/s: Not Applicable
Resolution: Fixed
> 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
> Priority: Major
> Fix For: Not Applicable
>
>
> 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)
