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)