Hi Pavan, for your lookup table, you need to lookup on the value? Not on the they? If that's the case, just "revert" your table into a secondary index lookup table where the value will be the key, and the key will be the value. That way you just to a get on this secondary index lookup table instead of doing a scan...
Make sense? JM 2013/7/31 Pavan Sudheendra <[email protected]> > Before inserting a row in my main table, i need to do a lookup on my > lookup table. I'm really not sure what logic has to be behind this. > Should i do a full table scan of the lookup table every single time i > insert in the main table? > > Thanks jean > > > > On Wed, Jul 31, 2013 at 6:10 PM, Jean-Marc Spaggiari > <[email protected]> wrote: > > 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 > >> > > > > -- > Regards- > Pavan >
