[
https://issues.apache.org/jira/browse/SPARK-44419?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17743075#comment-17743075
]
Hudson commented on SPARK-44419:
--------------------------------
User 'caican00' has created a pull request for this issue:
https://github.com/apache/spark/pull/42000
> Support to extract partial filters of datasource v2 table and push them down
> ----------------------------------------------------------------------------
>
> Key: SPARK-44419
> URL: https://issues.apache.org/jira/browse/SPARK-44419
> Project: Spark
> Issue Type: Improvement
> Components: SQL
> Affects Versions: 3.1.2, 3.2.0, 3.3.0, 3.4.0
> Reporter: caican
> Priority: Major
>
>
> Run the following sql, and the date predicate in the where clause is not
> pushed down and it would cause a full table scan.
>
> {code:java}
> SELECT
> id,
> data,
> date
> FROM
> testcat.db.table
> where
> (date = 20221110 and udfStrLen(data) = 8)
> or
> (date = 20221111 and udfStrLen(data) = 8) {code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]