[SPARK-31818] Failure on pushing down filters with java.time.Instant values in ORC

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 3.0.0, 3.0.1
• Fix Version/s: 3.0.0
• Component/s: SQL
• Assignee: Max Gekk
• Reporter: Max Gekk
• Created: 25/May/20 12:23
• Updated: 26/May/20 01:36
• Resolved: 26/May/20 01:36

Description

When spark.sql.datetime.java8API.enabled is set to true, filters pushed down with java.time.Instant values to ORC datasource fails with the exception:

[info]   java.lang.IllegalArgumentException: Wrong value class java.time.Instant for TIMESTAMP.EQUALS leaf
[info]   at org.apache.hadoop.hive.ql.io.sarg.SearchArgumentImpl$PredicateLeafImpl.checkLiteralType(SearchArgumentImpl.java:192)
[info]   at org.apache.hadoop.hive.ql.io.sarg.SearchArgumentImpl$PredicateLeafImpl.<init>(SearchArgumentImpl.java:75)
[info]   at org.apache.hadoop.hive.ql.io.sarg.SearchArgumentImpl$BuilderImpl.equals(SearchArgumentImpl.java:352)
[info]   at org.apache.spark.sql.execution.datasources.orc.OrcFilters$.buildLeafSearchArgument(OrcFilters.scala:234)
[info]   at org.apache.spark.sql.execution.datasources.orc.OrcFilters$.convertibleFiltersHelper$1(OrcFilters.scala:134)
[info]   at org.apache.spark.sql.execution.datasources.orc.OrcFilters$.$anonfun$convertibleFilters$4(OrcFilters.scala:137)
[info]   at scala.collection.TraversableLike.$anonfun$flatMap$1(TraversableLike.scala:245)

Issue Links

• is a clone of: SPARK-31489 Failure on pushing down filters with java.time.LocalDate values in ORC
• links to: [Github] Pull Request #28636 (MaxGekk)
• links to: [Github] Pull Request #28636 (MaxGekk)