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.

Sign up for GitHub

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

Jump to bottom

Support Nested Queries in Mongo #5645

Closed
Tracked by #28005
camsaul opened this issue Jul 31, 2017 · 1 comment · Fixed by #27615
Closed
Tracked by #28005

Support Nested Queries in Mongo #5645

camsaul opened this issue Jul 31, 2017 · 1 comment · Fixed by #27615
Assignees
@metamben
Labels
Database/Mongo .Limitation Querying/Nested Queries Questions based on other saved questions .Team/QueryProcessor :hammer_and_wrench: Type:New Feature
Milestone
0.46

Comments

@camsaul
Copy link
Member

camsaul commented Jul 31, 2017 •
edited

So far we only support Nested Queries for SQL databases but it seems like it would be possible to add Mongo support as well. Not sure how simple it would be. Opening this issue so we have a place to track it / don't forget about it.

⬇️ Please click the 👍 reaction instead of leaving a +1 or 👍 comment
@camsaul camsaul added Database/Mongo Querying/Nested Queries Questions based on other saved questions Proposal labels Jul 31, 2017
@salsakran salsakran mentioned this issue Sep 7, 2017
Closed
@camsaul camsaul mentioned this issue May 13, 2020
Merged
@flamber flamber mentioned this issue May 18, 2022
Closed
@camsaul
Copy link
Member Author

camsaul commented Dec 12, 2022

Since MongoDB aggregation pipeline queries are just sequences of pipeline stages it seems like supporting nested queries for MongoDB would simply be a matter of recursively compiling the source query and then prepending its stages to the beginning of the query. We might have to do a little work to map the columns from the source query correctly but it should be easier than the SQL QP drivers because we don't need to worry about joins

@metamben metamben self-assigned this Jan 5, 2023
@metamben metamben mentioned this issue Jan 10, 2023
Merged
@camsaul camsaul added this to the 0.46 milestone Feb 1, 2023
@camsaul camsaul mentioned this issue Feb 1, 2023
Closed
@darksciencebase darksciencebase added the .Team/QueryProcessor :hammer_and_wrench: label Mar 22, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@metamben metamben

Labels
Database/Mongo .Limitation Querying/Nested Queries Questions based on other saved questions .Team/QueryProcessor :hammer_and_wrench: Type:New Feature
Projects
None yet
Milestone
0.46
Development

Successfully merging a pull request may close this issue.

Support nested queries for MongoDB metabase/metabase
4 participants
@flamber @camsaul @metamben @darksciencebase