kerwin-zk commented on PR #7224: URL: https://github.com/apache/paimon/pull/7224#issuecomment-3870247145
> Why do we need to support this? Are there any beneficial queries? ```DELETE FROM t1 WHERE pt IN (SELECT id FROM t2 WHERE n > 10) OR pt = 3``` The subquery (n > 10) returns empty, evalSubquery replaces it with Literal(false). After translateFilterV2, this becomes: V2Or(ALWAYS_FALSE, V2EqualTo(pt, 3)). Without supporting ALWAYS_FALSE in SparkV2FilterConverter, the OR conversion would fail, falling back to the expensive row-level delete instead of partition dropping. -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
