You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@drill.apache.org by "Michelle (Jira)" <ji...@apache.org> on 2019/10/25 21:27:00 UTC

[jira] [Created] (DRILL-7422) mapr drill, query with order by does not use index

Michelle created DRILL-7422:
-------------------------------

             Summary: mapr drill, query with order by does not use index
                 Key: DRILL-7422
                 URL: https://issues.apache.org/jira/browse/DRILL-7422
             Project: Apache Drill
          Issue Type: Task
          Components: Functions - Drill
    Affects Versions: 1.16.0
            Reporter: Michelle


Hi there 

I am trying to optimize drill in mapr cluster, so it can perform as i think it should.

I have this query : select * from dfs.`mypath` ORDER BY myindex DESC LIMIT 10;

And it does not use the index, in the query plan.

But as soon as i use a WHERE clause, the index is being used.

Do some of you know, anything ?  

 



--
This message was sent by Atlassian Jira
(v8.3.4#803005)