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
