Yes perfect. Could i get few examples on how to create a secondary lookup table?
On Wed, Jul 31, 2013 at 7:01 PM, Jean-Marc Spaggiari <[email protected]> wrote: > 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 >> -- Regards- Pavan
