[
https://issues.apache.org/jira/browse/HIVE-25352?focusedWorklogId=713135&page=com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel#worklog-713135
]
ASF GitHub Bot logged work on HIVE-25352:
-----------------------------------------
Author: ASF GitHub Bot
Created on: 22/Jan/22 00:11
Start Date: 22/Jan/22 00:11
Worklog Time Spent: 10m
Work Description: github-actions[bot] commented on pull request #2499:
URL: https://github.com/apache/hive/pull/2499#issuecomment-1018984814
This pull request has been automatically marked as stale because it has not
had recent activity. It will be closed if no further activity occurs.
Feel free to reach out on the d...@hive.apache.org list if the patch is in
need of reviews.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: gitbox-unsubscr...@hive.apache.org
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
Issue Time Tracking
-------------------
Worklog Id: (was: 713135)
Time Spent: 20m (was: 10m)
> Optimise DBTokenStore for RDBMS
> -------------------------------
>
> Key: HIVE-25352
> URL: https://issues.apache.org/jira/browse/HIVE-25352
> Project: Hive
> Issue Type: Improvement
> Reporter: Sahana Bhat
> Assignee: Sahana Bhat
> Priority: Major
> Labels: pull-request-available, pull_request_available
> Time Spent: 20m
> Remaining Estimate: 0h
>
> The existing DBTokenStore implementation is very under optimised when an
> RDBMS is used.
> * All available tokens are fetched from the DB. The validity of each token
> is determined based on its max date and renew date and deleted if required.
> For a relational database like MySQL, a *query to fetch all rows with no
> filters or pagination* can be costly and impact the performance of the
> database and the server.
> * From the token identifiers fetched, if the token hasn’t breached its max
> date, the token information is again fetched from the database to validate
> its renew date.
> * The token expiration daemon is part of the Hive system. In a cluster of
> tens or hundreds of Hive servers, the daemon runs on each of the servers.
> This means that the flow of fetching of tokens, validation for expiration and
> deleting them is executed in duplication in each of the servers. The
> *duplication of the functionality in every server* along with the problems
> discussed in Point 1 & 2, can severely degrade the performance of the
> database.
> This issue will address the issues mentioned in 1 & 2.
--
This message was sent by Atlassian Jira
(v8.20.1#820001)
