Thanks for the reply. Currently the json files (dfs plugin) doesn't support usage of indexes.
Thanks, On Sun, Feb 10, 2019 at 12:58 PM Krishnanand Khambadkone <[email protected]> wrote: > I am querying raw json files directly from the file system (dfs) > > Sent from my iPhone > > > On Feb 10, 2019, at 12:19 PM, hanu mapr <[email protected]> wrote: > > > > This message is eligible for Automatic Cleanup! ([email protected]) > Add cleanup rule | More info > > Hi, > > > > Storage plugin needs to be enhanced to handle the indexing capabilities > for > > the corresponding storage engines. Indexing is supported by some of the > > databases like MongoDB, MapRDB etc. Currently, Drill's MapRDB storage > > plugin is enhanced to support the indexing mechanisms for MapRDB. If you > > are using any other storage engine then the corresponding storage plugin > > needs to be enhanced in the similar lines. The indexing API is nicely > > abstracted out so as to easily integrate other storage engines which > > support indexing mechanisms. > > > > Please let us know the storage engine you are trying to use? > > > > Hope this helps. > > > > Thanks, > > > > On Sun, Feb 10, 2019 at 10:29 AM Krishnanand Khambadkone > > <[email protected]> wrote: > > > >> Hi, I have a query where I am using say column a in the where , group > by > >> and order by clauses. I would like to add an index for this column. > How > >> can this be done? > >> Will this one do it > >> ALTER SYSTEM SET `planner.enable_index_planning` = true > >> >
