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)

Reply via email to