Hi @Col1ns ,
All the things mentioned by @lingareddy_Alva are correct. Some additional things to consider. Check if your implementation of Delta Sharing supports predicate hints.
Also, if your server supports them then your predicate should use restricted SQL Expression for filtering. Below expression are permitted:
Expression Example
| = | col = 123 |
| > | col > 'foo' |
| < | 'foo' < col |
| >= | col >= 123 |
| <= | 123 <= col |
| <> | col <> 'foo' |
| IS NULL | col IS NULL |
| IS NOT NULL | col IS NOT NULL |
Also, predicateHints will be deprecated once all the client and server implementation move to using jsonPredicateHints. So, from now on you should try to use jsonPredicateHints. You can read more about it in protocol description:
delta-sharing/PROTOCOL.md at main · delta-io/delta-sharing · GitHub
And last by not least, check you delta sharing server configuration. If you want to use this feature, following flag should be set to true:
