[ 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 taking 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 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.) > Determine the database type once the PersistenceManagerFactory created > ---------------------------------------------------------------------- > > 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 taking much time to > connect to the Metastore. -- This message was sent by Atlassian Jira (v8.20.10#820010)