[SPARK-40732] Make (SQL|ThriftServer)QueryTestSuite pass except Pandas UDF tests in Java 21

• Type: Sub-task
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 3.4.0
• Fix Version/s: 3.5.0
• Component/s: SQL
• Assignee: Dongjoon Hyun
• Reporter: Yang Jie
• Created: 10/Oct/22 14:14
• Updated: 19/Jun/23 17:00
• Resolved: 19/Jun/23 16:59

Description

Some case in SQLQueryTestSuite(sql/core) and ThriftServerQueryTestSuite(sql/hive-thriftserver) failed for this reason:

for example:

 

SQLQueryTestSuite- 

try_aggregates.sql *** FAILED ***
  try_aggregates.sql
  Expected "4.61168601842738[79]E18", but got "4.61168601842738[8]E18" Result did not match for query #20
  SELECT try_avg(col) FROM VALUES (9223372036854775807L), (1L) AS tab(col) (SQLQueryTestSuite.scala:495) 

ThriftServerQueryTestSuite- try_aggregates.sql *** FAILED ***
  Expected "4.61168601842738[79]E18", but got "4.61168601842738[8]E18" Result did not match for query #20
  SELECT try_avg(col) FROM VALUES (9223372036854775807L), (1L) AS tab(col) (ThriftServerQueryTestSuite.scala:222)- try_arithmetic.sql *** FAILED ***
  Expected "-4.65661287307739[26]E-10", but got "-4.65661287307739[3]E-10" Result did not match for query #26
  SELECT try_divide(1, (2147483647 + 1)) (ThriftServerQueryTestSuite.scala:222)- datetime-

Issue Links

• relates to: SPARK-43831 Build and Run Spark on Java 21
• links to: [Github] Pull Request #41658 (dongjoon-hyun)
• links to: JDK-4511638