[
https://issues.apache.org/jira/browse/HIVE-28460?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Zhihua Deng updated HIVE-28460:
-------------------------------
Description: Upon ObjectStore initialization, we need to determine which
type of underlying db is by asking the connection the product name. It's a
waste of time and resource to do this, as long as we don't change the database
connection information, the db type shouldn't be changed, sometimes retrieving
the connection for the secondary connection pool(which size is 2) could be time
cost, which can lead to HiveMetastoreClient spending much time to connect to
the Metastore. (was: Upon ObjectStore initialization, we need to determine
which type of underlying db is by asking the connection the product name. It's
a waste of time and resource to do this, as long as we don't change the
database connection information, the db type shouldn't be changed, sometimes
1. Determine the database product once instead of every time on ObjectStore
initialization;
2. Extract the ObjectStore methods designed for HiveMetaTool to a standalone
class;
3. Remove some dangling codes.)
> Cleanup some dangling codes around the Metastore
> ------------------------------------------------
>
> Key: HIVE-28460
> URL: https://issues.apache.org/jira/browse/HIVE-28460
> Project: Hive
> Issue Type: Improvement
> Reporter: Zhihua Deng
> Assignee: Zhihua Deng
> Priority: Major
> Labels: pull-request-available
>
> Upon ObjectStore initialization, we need to determine which type of
> underlying db is by asking the connection the product name. It's a waste of
> time and resource to do this, as long as we don't change the database
> connection information, the db type shouldn't be changed, sometimes
> retrieving the connection for the secondary connection pool(which size is 2)
> could be time cost, which can lead to HiveMetastoreClient spending much time
> to connect to the Metastore.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
