This will largely depend on the implementation of the Mongo DB storage
plugin. Based on my glimpse at the plugin code [1], it looks like we read
all the data from Mongo DB and then aggregation in drill
[1]
Hi Andy,
Please find the answer inline.
Then, i have 2 thinking on this:
1. Drill will use aggregate from MongoDB's api to do GROUP BY
>> Currently Drill's mongo plugin will not push down group by operator to
mongo DB.
2. Drill will filter data ( find from Mongo API) then it will do
aggregation
Hi, Drill Team
My name is Andy.
Currently, Im considering to use Apache Drill to query and aggregate data
from MongoDB.
But I really confused how does it work about aggregation.
For example i have this query:
SELECT user,SUM(amount)
FROM sales WHERE type=1
GROUP BY user
Then, i have 2 thinking