[Feature] add hive catalog for test case

### Search before asking

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

### Motivation

Now, many test cases are based on file catalogs ，for example `org.apache.paimon.flink.CatalogITCaseBase` ,

I found that some case is fine in file catalog, but it is will throw an exception in hive catalog, like https://github.com/apache/incubator-paimon/issues/1542

so I think we need to add more test case for hive catalog (and different hive version)

### Solution

_No response_

### Anything else?

_No response_

### Are you willing to submit a PR?

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

Start with org.apache.paimon.flink.CatalogITCaseBase and issue 1542 to identify cases that pass with the file catalog but fail with Hive. Review the existing test setup and supported Hive versions, then add coverage for the relevant Hive catalog scenarios and verify the tests across those versions.

Written by the indexing model from the issue text.