drill-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From AnilKumar B <akumarb2...@gmail.com>
Subject Re: [MongoDB] How does drill aggregate data
Date Mon, 02 Oct 2017 16:32:34 GMT
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 by its own way ( such as: collect all matching documents onto
memory & do group by )
>> Yes, it works in this way.

Thanks,
B Anil Kumar.



Thanks & Regards,
B Anil Kumar.

On Mon, Oct 2, 2017 at 8:42 AM, Andy <tauit.dnmd@gmail.com> wrote:

> 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