[VL] Enable more hive related unit tests

[zhouyuan]

Description

Gluten now ported more unit tests from sql/core. However there are some hive related unit tests are missed.
https://github.com/apache/spark/tree/master/sql/hive/src/test

Gluten version

None

[rui-mo]

Related issue #8729.

[wecharyu]

I’d like to take this. The failing tests in facebookincubator/velox#16855 are Spark Hive unit tests, and bringing them into Gluten would be a good way to verify the fix.