[
https://issues.apache.org/jira/browse/SPARK-53596?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18021468#comment-18021468
]
Aparna Garg commented on SPARK-53596:
-------------------------------------
User 'joeyutong' has created a pull request for this issue:
https://github.com/apache/spark/pull/52352
> Put translatable filters to the left side of untranslatable filters
> -------------------------------------------------------------------
>
> Key: SPARK-53596
> URL: https://issues.apache.org/jira/browse/SPARK-53596
> Project: Spark
> Issue Type: Bug
> Components: SQL
> Affects Versions: 4.0.1
> Reporter: Yu Tang
> Priority: Major
>
> Inspired by [40045|https://issues.apache.org/jira/browse/SPARK-40045], to put
> translatable filters to the left side of untranslatable filters in
> `FileSourceStrategy`
> {code:java}
> select xxx from table where hash(c2) = 2 AND p1 = 1 AND c1 = 1{code}
> before
> {code:java}
> *(1) Filter ((isnotnull(c1#0) AND (hash(c2#1, 42) = 2)) AND (c1#0 = 1)) {code}
> after
> {code:java}
> *(1) Filter ((isnotnull(c1#0) AND (c1#0 = 1)) AND (hash(c2#1, 42) = 2)){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]
