[hive] add hive client pool

[zhuangchong]

Purpose

add hive client pool

Tests

API and Format

Documentation

[XuQianJin-Stars]

hi @zhuangchong Is there any difference between this PR and #2567 ?The e2e test has been unstable before.

[zhuangchong]

hi @zhuangchong Is there any difference between this PR and #2567 ?The e2e test has been unstable before.

There is no difference. PR 2567 has not been updated for a long time, and this feature is very needed, so I launched a PR again, merging the latest code and solving the UT exception.

If you have time and are willing to update PR 2567, I can close this PR. @XuQianJin-Stars

[XuQianJin-Stars]

hi @zhuangchong Is there any difference between this PR and #2567 ?The e2e test has been unstable before.

There is no difference. PR 2567 has not been updated for a long time, and this feature is very needed, so I launched a PR again, merging the latest code and solving the UT exception.

If you have time and are willing to update PR 2567, I can close this PR. @XuQianJin-Stars

I understand. I don't care about this PR merge. I will close PR 2567. The reason I left a comment is to tell me you want to use this PR 2567.

[caicancai]

hi @zhuangchong I think it's ok to add XuQianJin-Stars as co-author

[zhuangchong]

hi @zhuangchong I think it's ok to add XuQianJin-Stars as co-author

Where is this added?

[zhangjun0x01]

hi @zhuangchong I think it's ok to add XuQianJin-Stars as co-author

Where is this added?

For this situation, I think you can make changes based on the original pr and then push the modified code to the original author's repository

[caicancai]

For this situation, I think you can make changes based on the original pr and then push the modified code to the original author's repository

@zhuangchong Add co-author information in the commit message， for example:

apache/calcite@f0dc2b0

[JingsongLi]

Hi @zhuangchong
What is the status? I remember passing the test? What have you done now?

[zhuangchong]

Hi @zhuangchong What is the status? I remember passing the test? What have you done now?

@JingsongLi I merged the latest code, and then ut error package cannot be found, I am looking for the problem.

[JingsongLi]

@zhuangchong You mean you just cherry-picked #2567 ? Why not kust keep your code?

[zhuangchong]

@zhuangchong You mean you just cherry-picked #2567 ? Why not kust keep your code?

The CI is experiencing anomalies after merging the latest code into the master branch.

[sunxiaojian]

Is CachedClientPool considering creating an abstraction layer? JdbcClientPool may also need to be implemented through caching

[JingsongLi]

Sorry for the late reply.

I've been thinking for a long time, why do we need a client pool? Are there any user needs?

[zhuangchong]

Sorry for the late reply.

I've been thinking for a long time, why do we need a client pool? Are there any user needs?

A user reported that Paimon uses hive catalog, and the number of hive metastore connections exceeds 10,000.

[waywtdcc]

Sorry for the late reply.
I've been thinking for a long time, why do we need a client pool? Are there any user needs?

A user reported that Paimon uses hive catalog, and the number of hive metastore connections exceeds 10,000.

+1,I also encountered this situation, the number of hive metastore connections exceeded 2000+

[JingsongLi]

+1