drill-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Andy <tauit.d...@gmail.com>
Subject [MongoDB] How does drill aggregate data
Date Mon, 02 Oct 2017 15:42:57 GMT
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 on this:
1. Drill will use aggregate from MongoDB's api to do GROUP BY
2. Drill will filter data ( find from Mongo API) then it will do
aggregation by its own way ( such as: collect all matching documents onto
memory & do group by )

So, can you help me to understand how it works
Thanks in advanced

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message