[jira] [Commented] (DRILL-3165) Sorting a Mongo table should leverage Mongo Indexes

["B Anil Kumar (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/DRILL-3165?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14554634#comment-14554634 ] 

B Anil Kumar commented on DRILL-3165:
-------------------------------------

Hi Leandro,

As of now, operator pushdown is not implemented in mongo storage plugin.

We are working on group, sort, limit operators pushdown, with this it should be fast.  

> 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
>            Assignee: B Anil Kumar
>
> 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)