accumulo-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From vaibhav thapliyal <vaibhav.thapliyal...@gmail.com>
Subject Re: Indexing Column Values in Accumulo
Date Mon, 10 Oct 2016 10:09:46 GMT
Creating an Inverted Index could serve your use case. You can store the
column family and column qualifier both in the row of the index table
separated by a delimiter.

For eg cf|cq

And then perform queries on just the row id to get a low query time.

On 29 September 2016 at 11:03, Josh Elser <josh.elser@gmail.com> wrote:

> Hi Yamini,
>
> You're right that a filter would have to exhaustively search a table to
> find all rows that contain a certain family and qualifier. If you
> explicitly know the rows that you want to search, this is a fast operation.
>
> Have you considered creating an inverted index? This would be a table that
> you have to maintain on your own. Accumulo does not provide automatic index
> generation.
>
> - Josh
>
>
> Yamini Joshi wrote:
>
>> Hello everyone
>>
>> Is there a way to easily index column fields for efficient lookups in
>> Accumulo? My use case is to select the records containing a certain
>> column family and column qualifier from among a set of column
>> qualifiers(reverse lookup). Although this could be done using a custom
>> filter, I'm looking for an optimal solution (since filter might scan the
>> entire database).
>>
>> Best regards,
>> Yamini Joshi
>>
>

Mime
View raw message