[Bug] flink sql-gateway use paimon-generic （use Hive metastore）

### Search before asking

- [X] I searched in the [issues](https://github.com/apache/paimon/issues) and found nothing similar.

### Paimon version

0.0.8

### Compute Engine

Flink

### Minimal reproduce step

...

### What doesn't meet your expectations?

flink sql-gateway（hiveserver2） use paimon-generic （use Hive metastore）
使用DBeaver通过flink的sql-gateway（hiveserver2）链接flink，然后创建catalog（paimon-generic ）AND 此catalog下的表，sql connection关闭后重新打开一个新的sql connection，之前创建的catalog（paimon-generic ）AND 此catalog下的表就没了

### Anything else?

_No response_

### Are you willing to submit a PR?

- [ ] I'm willing to submit a PR!

Start by reproducing the behavior through Flink SQL Gateway (HiveServer2) with DBeaver, using a paimon-generic catalog backed by Hive metastore. Compare the catalog and table state before and after closing and reopening the SQL connection; done means the catalog and its tables remain available in the new connection.

Written by the indexing model from the issue text.