drill-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Leandro DG (JIRA)" <j...@apache.org>
Subject [jira] [Created] (DRILL-3165) Sorting a Mongo table should leverage Mongo Indexes
Date Thu, 21 May 2015 16:15:17 GMT
Leandro DG created DRILL-3165:

             Summary: 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