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 <[email protected]> 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 >> >
