[Improvement] Hive connector support HADOOP_HOME envirnoment variable

### Code of Conduct

- [X] I agree to follow this project's [Code of Conduct](https://www.apache.org/foundation/policies/conduct)

### Search before asking

- [X] I have searched in the [issues](https://github.com/apache/incubator-kyuubi/issues?q=is%3Aissue) and found no similar issues.

### What would you like to be improved?

Currently, the Hive connector only reads HADOOP_CONF_DIR, we can support setting any of HADOOP_CONF_DIR or HADOOP_HOME.

### How should we improve?

_No response_

### 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.

Locate the Hive connector code that currently reads HADOOP_CONF_DIR and trace how its environment configuration is resolved. Verify the connector works when either HADOOP_CONF_DIR or HADOOP_HOME is set, and add or update coverage for both cases if the existing test structure supports it.

Written by the indexing model from the issue text.