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

["Leandro DG (JIRA)" <ji...@apache.org>]

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
(v6.3.4#6332)