AnsweredAssumed Answered

Slow drill query against MapR DB with secondary index

Question asked by tongqqiu on Apr 10, 2018
Latest reply on May 23, 2018 by maprcommunity

I created maprDB json table with 10M records in it, and added secondary index on a field. 

 

The query using OJAI is very fast, but same query using drill is very slow (took minutes). 

 

Any idea what is the issue? And how to troubleshoot?

 

MapR version 6.0.1

Drillbit version 1.13.0-mapr

Outcomes