[SPARK-31488] Support `java.time.LocalDate` 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: 19/Apr/20 15:56
• Updated: 26/Jul/20 05:52
• Resolved: 24/Apr/20 02:22

Description

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

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

Issue Links

• is cloned by: SPARK-31888 Support `java.time.Instant` in Parquet filter pushdown
• links to: [Github] Pull Request #28272 (MaxGekk)
• links to: [Github] Pull Request #29242 (abhishekd0907)
• links to: GitHub Pull Request #28259