drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "B Anil Kumar (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DRILL-3165) Sorting a Mongo table should leverage Mongo Indexes
Date Thu, 21 May 2015 16:45:18 GMT

    [ 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

View raw message