hbase-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Pavan Sudheendra <pavan0...@gmail.com>
Subject Re: How to get row key from row value?
Date Wed, 31 Jul 2013 13:01:43 GMT
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
<jean-marc@spaggiari.org> 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 <pavan0591@gmail.com>
>
>> 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
>> <jean-marc@spaggiari.org> 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 <pavan0591@gmail.com>
>> >
>> >> 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

Mime
View raw message