GitHub user dadepo closed a discussion: Does DataFusion Support JSON Path Filtering Like `jsonb_path_exists` in PostgreSQL?
PostgreSQL has a handy function called `jsonb_path_exists` that makes it easy to filter JSON data. For example: ``` SELECT * FROM table WHERE jsonb_path_exists(properties, '$.person.age ? (@ == 18)') ``` I’m wondering if there’s a way to do something similar in DataFusion using its Expression API. From what I’ve seen in the [docs](https://datafusion.apache.org/user-guide/expressions.html), it doesn’t look like this is currently supported, but I just wanted to check: - Is there a way to achieve this with existing DataFusion expressions? - If not, directly via the Expression function, is there a way to achieve it, maybe by using more low level primitives? Would love to hear any thoughts on this! GitHub link: https://github.com/apache/datafusion/discussions/15264 ---- This is an automatically sent email for [email protected]. To unsubscribe, please send an email to: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
