[Bug] hive engine error while the remote version is 2.3.9

### 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/kyuubi/issues?q=is%3Aissue) and found no similar issues.

### Describe the bug

while using the hive engine, the remote hive version is 2.3.9 ;
bin/beeline -u 'jdbc:hive2://10.0.30.14:10009/default?kyuubi.engine.type=HIVE_SQL' -n hive

error:

### Affects Version(s)

1.7.0

### Kyuubi Server Log Output

_No response_

### Kyuubi Engine Log Output

```logtalk
2023-09-07 11:34:17.538 ERROR org.apache.kyuubi.metrics.JsonReporterService: Error writing metrics to json file: /home/databig/apache-kyuubi-1.7.1-bin/work/metrics/report.json
java.nio.file.NoSuchFileException: /home/databig/apache-kyuubi-1.7.1-bin/work/metrics/report8146670077417272879.json
at sun.nio.fs.UnixException.translateToIOException(UnixException.java:86) ~[?:1.8.0_351]
at sun.nio.fs.UnixException.rethrowAsIOException(UnixException.java:102) ~[?:1.8.0_351]
at sun.nio.fs.UnixException.rethrowAsIOException(UnixException.java:107) ~[?:1.8.0_351]
at sun.nio.fs.UnixFileSystemProvider.newByteChannel(UnixFileSystemProvider.java:214) ~[?:1.8.0_351]
at java.nio.file.Files.newByteChannel(Files.java:361) ~[?:1.8.0_351]
at java.nio.file.Files.createFile(Files.java:632) ~[?:1.8.0_351]
at java.nio.file.TempFileHelper.create(TempFileHelper.java:138) ~[?:1.8.0_351]
at java.nio.file.TempFileHelper.createTempFile(TempFileHelper.java:161) ~[?:1.8.0_351]
at java.nio.file.Files.createTempFile(Files.java:852) ~[?:1.8.0_351]
at org.apache.kyuubi.metrics.JsonReporterService$$anon$1.run(JsonReporterService.scala:61) ~[kyuubi-metrics_2.12-1.7.1.jar:1.7.1]
at java.util.TimerThread.mainLoop(Timer.java:555) ~[?:1.8.0_351]
at java.util.TimerThread.run(Timer.java:505) ~[?:1.8.0_351]
```

### Kyuubi Server Configurations

```yaml
export JAVA_HOME=/usr/local/jdk1.8.0_351
export HIVE_HOME=/home/databig/apache-hive-3.1.3-bin
export HADOOP_CONF_DIR=/home/databig/hadoop-3.3.4/etc/hadoop
export HADOOP_HOME=/home/databig/hadoop-3.3.4
export HIVE_HADOOP_CLASSPATH=`${HADOOP_HOME}/bin/hadoop classpath`
```

### Kyuubi Engine Configurations

```yaml
hive.metastore.uris thrift://10.0.30.14:9083
kyuubi.engine.hive.java.options -agentlib:jdwp=transport=dt_socket,server=y,suspend=y,address=5005
```

### Additional context

remote hive version is 2.3.9

### Are you willing to submit PR?

- [ ] Yes. I would be willing to submit a PR with guidance from the Kyuubi community to fix.
- [ ] No. I cannot submit a PR at this time.