[
https://issues.apache.org/jira/browse/DRILL-3165?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15672707#comment-15672707
]
Mridul Chopra commented on DRILL-3165:
--------------------------------------
Hi Anil,
Do you have any update or progress made on operator pushdown implementation for
mongo storage plugin (specifically sorting) ?
I am running a merge join but drill tries to sort the data on its own rather
than sorting it at the mongo level.If the sorting can be pushed down to mongo
db level then it could be a huge performance boost.
Thanks
> Sorting a Mongo table should leverage Mongo Indexes
> ---------------------------------------------------
>
> Key: DRILL-3165
> URL: https://issues.apache.org/jira/browse/DRILL-3165
> Project: Apache Drill
> Issue Type: Improvement
> Components: Storage - MongoDB
> Affects Versions: 1.0.0
> Reporter: Leandro DG
> Fix For: Future
>
>
> When doing a query using Mongo, sorting takes place entirely in Drill.
> Getting the first 1000 rows from a 1000000 rows table, sorted by a field
> which has an index takes a long time (about 45 seconds in our test
> environment).
> Sample drill query:
> Select c.name from mongo.foo.json_customers c order by c.name limit 1000
> Doing the same in mongo client takes less than a second.
> Sample mongo query: db.json_customers.find().sort({"name":1}).limit(1000)
> Sorting by a field should leverage the existing mongo indexes if they exist.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
