[SPARK-12506] Push down WHERE clause arithmetic operator to JDBC layer

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Incomplete
• Component/s: SQL
• Labels: bulk-closed
• Assignee: Apache Spark
• Reporter: Huaxin Gao
• Created: 23/Dec/15 19:12
• Updated: 12/Dec/22 18:11
• Resolved: 21/May/19 04:34

Description

For arithmetic operator in WHERE clause such as

select * from table where c1 + c2 > 10

Currently where c1 + c2 >10 is done at spark layer.

Will push this to JDBC layer so it will be done in database.

Issue Links

• is related to: SPARK-12126 JDBC datasource processes filters only commonly pushed down.
• relates to: SPARK-12449 Pushing down arbitrary logical plans to data sources
• links to: [Github] Pull Request #10505 (huaxingao)
• links to: [Github] Pull Request #10750 (huaxingao)
• links to: [Github] Pull Request #11005 (huaxingao)