Hi @BTKR/Tej, Your subject and your actual question differ a lot and both are completely different things. If you are concerned about the number of connections going to Metastore database from the Hive Metastore process, you can use the below way: 1. Find out the PID of HMS process on the server using the below command: ps -ef | grep -i hivemetastore 2. Once you have the PID, get the put of below command: lsof -p PID | grep ESTABLISHED This will give you list of all the connections being made to and by the Hivemetastore process. This will also include the connections made "TO" Hivemetastore process from the clients i.e. from the Hive CLI shells. Please look for the database type in the output to confirm the connections FROM Hivemetastore to HMS DB. For example on my side, I have the below output: In the above photo, all the outputs that have "mysql" in it are being made from HiveMetastore Process to HMS DB. As per your question in the description, if you want to find out how many threads are try to connect to the database at any time, you can collect the jstack of the HMS process and then look for the threads referring the mysql calls(which is the database type in my case, you can look for oracle or postgres if any of those are your database types). Also, I get a feeling that you are concerned by the number of connections being made to the database. You can check the below property via Hive CLI and beeline(this property will not listed in the Ambari as it is built in): set datanucleus.connectionPool.maxPoolSize; --This will give to the connection pool size. 10 is the default value, if set to something else, please let me know. Also, share the output of below query: set datanucleus.connectionPoolingType; Do confirm the exact HDP version you are on!!! Please note the connection pool set to 10 does not mean there will only 10 connections to HMS DB, there can be more connections, but if this value is increased, the number of connections also increases exponentially to HMS DB. Sometimes, it is suggested to increase the connection pool size to accommodate the huge load of queries on Hive. So, if you are using your Hive services extensively, and the connectionpoolsize is set to a higher value, I would suggest to fix the issue on the HMS DB side to to allow more number of connections. For example, on MySQL, there is max_connections, you can increase it to 1000 or more. Let me know if the above information was helpful!! Thanks, Rohit Rai Malhotra
... View more
