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

• Type: Task
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 1.16.0
• Component/s: Functions - Drill
• Assignee: Unassigned
• Reporter: Michelle
• Created: 25/Oct/19 21:26
• Updated: 25/Oct/19 21:26

Description

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 ?