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
