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

Add support for the "contains" function pushdown for Mongodb #21043

Open
ZhangJianAo opened this issue Mar 13, 2024 · 1 comment · May be fixed by #21589
Open

Add support for the "contains" function pushdown for Mongodb #21043

ZhangJianAo opened this issue Mar 13, 2024 · 1 comment · May be fixed by #21589
Assignees

Comments

@ZhangJianAo
Copy link
Contributor

When using Trino with the Mongodb, when filtering on most primitive type fields can pushdown to mongo and has good performance. However, filtering on the array field will lead to a table scan and poor performance.
I am working on an improvement to pushdown the "contains" function to MongoDB. So when SQL has conditions like WHERE contains(colArray, -1), trino can pushdown to mongo using {"colArray": -1} to filter documents.

@ebyhr
Copy link
Member

ebyhr commented Mar 13, 2024

cc: @Praveen2112 @krvikash

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
2 participants