drill-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From hanu mapr <hanu.m...@gmail.com>
Subject Re: How to add an index
Date Mon, 11 Feb 2019 22:29:01 GMT
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
<kkhambadkone@yahoo.com.invalid> 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 <hanu.mapr@gmail.com> wrote:
> >
> >    This message is eligible for Automatic Cleanup! (hanu.mapr@gmail.com)
> 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
> > <kkhambadkone@yahoo.com.invalid> 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
> >>
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message