BIGTOP-3963: Merge hive memory leak PRs (for hive-3.1.3)

[rzuo]

Description of PR

Currently, Hive3 has some issues, especially following memory leak related issues, which have been blocked the usage of hive in production environment due to frequently OOM. For this reason, I'd like to merge them in patch format to bigtop project.

They are: HIVE-16455: ADD JAR command leaks JAR Files https://issues.apache.org/jira/browse/HIVE-16455 HIVE-24236/HIVE-25483: Connection leak in TxnHandler https://issues.apache.org/jira/browse/HIVE-24236 https://issues.apache.org/jira/browse/HIVE-25483 HIVE-24552: Possible HMS connections leak or accumulation in loadDynamicPartitions https://issues.apache.org/jira/browse/HIVE-24552

HIVE-24858: UDFClassLoader leak in Configuration.CACHE_CLASSES

https://issues.apache.org/jira/browse/HIVE-24858 HIVE-26404: HMS memory leak when compaction cleaner fails to remove obsolete files https://issues.apache.org/jira/browse/HIVE-26404 HIVE-26530: HS2 OOM-OperationManager.queryIdOperation does not properly clean up multiple queryIds (This PR has been fixed in hive-3.1.3) https://issues.apache.org/jira/browse/HIVE-26530

How was this patch tested?

Local smoke test:

1. create test database and test table (TPC-DS: web_sales)
2. load test data (1GB TPC-DS test data) to tables;
3. run select count(1) from web_sales;

For code changes:

• [ ] Does the title or this PR starts with the corresponding JIRA issue id (e.g. 'BIGTOP-3638. Your PR title ...')?
• [ ] Make sure that newly added files do not have any licensing issues. When in doubt refer to https://www.apache.org/licenses/