the best way is to insert on your lookup table each time you insert on your main table. That way you don't have to scan your entire main table to build the lookup table...
If you want to filter by CF you can look at http://hbase.apache.org/apidocs/org/apache/hadoop/hbase/filter/FamilyFilter.html . Basically, you have all the filters listed there: http://hbase.apache.org/apidocs/org/apache/hadoop/hbase/filter/package-summary.html You should be able to find one which match your needs. JM 2013/7/31 Pavan Sudheendra <[email protected]> > Hi Jean, > Is there a way to specify column family, column qualifier and column > value to get the row key without having to scan the table every single > time? > Basically, i'm building a lookup table which helps in insertion of > another HBase table. its quite complicated to explain. > > On Wed, Jul 31, 2013 at 5:53 PM, Jean-Marc Spaggiari > <[email protected]> wrote: > > Hi Pavan, > > > > Are you looking for something like > > > http://hbase.apache.org/apidocs/org/apache/hadoop/hbase/filter/ValueFilter.html > ? > > > > You are going to do a table full scan... If you value is uniq, you might > > want to build a secondary index table for direct access... > > > > JM > > > > 2013/7/31 Pavan Sudheendra <[email protected]> > > > >> How do i get the row key by specifying a row value assuming row values > >> are unique? > >> > >> What API should i use for this purpose? > >> -- > >> Regards- > >> Pavan > >> > > > > -- > Regards- > Pavan >
