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