[Subtask] Add tests to check for consistency with V1 in hive connector

[yikf]

Code of Conduct

• [X] I agree to follow this project's Code of Conduct

Search before asking

• [X] I have searched in the issues and found no similar issues.

Describe the subtask

Add tests to check for consistency with V1

Parent issue

https://github.com/apache/incubator-kyuubi/issues/3365

Are you willing to submit PR?

• [X] Yes. I can submit a PR independently to improve.
• [ ] Yes. I would be willing to submit a PR with guidance from the Kyuubi community to improve.
• [ ] No. I cannot submit a PR at this time.