[VL] Track on Spark-4.0 failed unit tests

[zhouyuan]

Please leave a comment and mark on the TODO tests in this issue if you want to contribute

Backend

VL (Velox)

Bug description

After #10725 the general framework of unit tests are merged. We still have failed unit tests left here:

Velox backend

Sutie	Owner / PR
NativeBenchmarkPlanGenerator.scala	✅#11144 @marin-ma
MiscOperatorSuite	✅#11147 @marin-ma
ArrowEvalPythonExecSuite	✅#11288 @zhztheplayer
ArithmeticAnsiValidateSuite	✅#11150 @marin-ma
JsonFunctionsValidateSuite	✅#11294 @baibaichen
DateFunctionsValidateSuite	✅#11171 @zml1206
ScalarFunctionsValidateSuite	✅ #11170 #11180 @marin-ma

Gluten UT

Sutie	Owner / PR
GlutenSQLQueryTestSuite	#11136 @zhouyuan
GlutenKeyGroupedPartitioningSuite	✅ #11184 @jinchengchenghh
GlutenQueryExecutionErrorsSuite	✅ #11185 @marin-ma
GlutenCastSuite	✅ #11181 @marin-ma
GlutenTryCastSuite	✅ #11181 @marin-ma
GlutenJsonFunctionsSuite	✅#11276 @baibaichen
GlutenCSVv1Suite	#11190 @jinchengchenghh
GlutenCSVv2Suite	#11190 @jinchengchenghh
GlutenCSVLegacyTimeParserSuite	#11190 @jinchengchenghh
GlutenCSVReadSchemaSuite	#11190 @jinchengchenghh
GlutenHeaderCSVReadSchemaSuite	#11190 @jinchengchenghh
GlutenParquetV1FilterSuite	✅ #11359 ✅ facebookincubator/velox#15676 @baibaichen
GlutenParquetV2FilterSuite	✅ #11359 ✅ facebookincubator/velox#15676 @baibaichen
GlutenParquetIOSuite	✅#11281 @baibaichen
GlutenParquetSchemaSuite	✅#11276 @baibaichen
GlutenParquetReadSchemaSuite	✅ #11359 ✅ facebookincubator/velox#15657 @baibaichen
GlutenVectorizedParquetReadSchemaSuite	✅ #11359 ✅ facebookincubator/velox#15657 @baibaichen
GlutenCoalesceShufflePartitionsSuite	✅ #11201 @marin-ma
GlutenTakeOrderedAndProjectSuite	✅#11194 @zml1206
GlutenInsertSuite	✅ #11200 @jinchengchenghh
GlutenFileSourceCharVarcharTestSuite	✅ #11202 @jinchengchenghh
GlutenDataFrameFunctionsSuite	✅#11195 @zml1206
GlutenDataFrameStatSuite	✅ #11211 @marin-ma
GlutenDatasetSuite	✅ #11197 @zhli1142015
GlutenDynamicPartitionPruningV1SuiteAEOn	✅ #11212 @jinchengchenghh
GlutenSQLQuerySuite	✅ #11252 @marin-ma
GlutenCollapseProjectExecTransformerSuite	✅#11206 @zml1206
GlutenDeltaBasedMergeIntoTableSuite	✅ #11204 @zhli1142015
GlutenDeltaBasedMergeIntoTableUpdateAsDeleteAndInsertSuite	✅ #11204 @zhli1142015
GlutenGroupBasedMergeIntoTableSuite	✅ #11204 @zhli1142015
GlutenStreamingQuerySuite	✅#11223 @marin-ma
GlutenQueryExecutionSuite	#11382 @zhztheplayer
GlutenDateExpressionsSuite	✅#11172 @zml1206

---

Enable hive suite
https://github.com/apache/spark/blob/master/sql/hive/src/test/scala/org/apache/spark/sql/hive/TestHiveSuite.scala

[FelixYBW]

@baibaichen @weiting-chen FYI

[zhouyuan]

ANSI related work: #10134

[baibaichen]

Hi @zhouyuan , I’ve updated the tracking.

Please @ yourself next to any suite you start or fix so we avoid duplication. Thanks.

[zhouyuan]

Gluten has a gap on enabling on hive tests, it's a good oppty for us to enable this in Spark-4.0
hive tests related: #10072