[SPARK-31888] Support `java.time.Instant` in Parquet filter pushdown

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 3.0.0, 3.1.0
• Fix Version/s: 3.0.0
• Component/s: SQL
• Assignee: Max Gekk
• Reporter: Max Gekk
• Created: 01/Jun/20 17:23
• Updated: 02/Jun/20 12:23
• Resolved: 02/Jun/20 11:54

Description

Currently, ParquetFilters supports only java.sql.Timestamp values of TimestampType, and explicitly casts Any to java.sql.Timestamp, see
https://github.com/apache/spark/blob/cb0db213736de5c5c02b09a2d5c3e17254708ce1/sql/core/src/main/scala/org/apache/spark/sql/execution/datasources/parquet/ParquetFilters.scala#L180

So, any filters refer to timestamp values are not pushed down to Parquet when spark.sql.datetime.java8API.enabled is true.

Issue Links

• is a clone of: SPARK-31488 Support `java.time.LocalDate` in Parquet filter pushdown
• links to: [Github] Pull Request #28696 (MaxGekk)