drill-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Krishnanand Khambadkone <kkhambadk...@yahoo.com.INVALID>
Subject Re: How to add an index
Date Sun, 10 Feb 2019 20:58:07 GMT
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

  • Unnamed multipart/alternative (inline, 7-Bit, 0 bytes)
View raw message