Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Filter: operators for working with MAPs #337

Open
rpbouman opened this issue Dec 29, 2024 · 1 comment
Open

Filter: operators for working with MAPs #337

rpbouman opened this issue Dec 29, 2024 · 1 comment
Labels
enhancement New feature or request

Comments

@rpbouman
Copy link
Owner

          We have a similar opportunity for MAP types:

element_at: https://duckdb.org/docs/sql/functions/map#element_atmap-key
map_contains: https://duckdb.org/docs/sql/functions/map#map_containsmap-key
map_contains_key: https://duckdb.org/docs/sql/functions/map#map_contains_valuemap-value
map_contains_entry(map, key, value)](https://duckdb.org/docs/sql/functions/map#map_contains_entrymap-key-value)

Originally posted by @rpbouman in #318 (comment)

@rpbouman
Copy link
Owner Author

Let's hold off on this untill the next DuckDB version drops. I noticed that the JSON reader has some changes which causes the blueworks dataset to return propery structs instead of MAPs, and also the MAP extraction methods have change so as to not return an array anymore. If we build this now we may find we have to redo it again.

@rpbouman rpbouman added the enhancement New feature or request label Dec 31, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
enhancement New feature or request
Projects
None yet
Development

No branches or pull requests

1 participant