chenjian2664 opened a new pull request, #11004:
URL: https://github.com/apache/paimon/pull/11004

   ### Purpose
   
   Filtering a system table on a function of a column fails with 
`UnsupportedOperationException`, for example `SELECT * FROM t$tags WHERE 
upper(tag_name) = 'X'` in Spark. Spark pushes `UPPER`, `SUBSTRING`, `CAST` and 
similar predicates down as Paimon transforms, and `LeafPredicateExtractor` 
throws for any leaf that is not a plain field. All system tables that push down 
filters are affected, including `$files`, `$snapshots`, `$tags` and `$branches`.
   
   Such a leaf now adds no field constraint, so pushdown skips it and the 
predicate is still evaluated on the rows.
   
   ### Tests


-- 
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]

Reply via email to