hbase-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Michael Segel <michael_se...@hotmail.com>
Subject Re: observer coprocessor question regarding puts
Date Mon, 10 Jun 2013 19:42:16 GMT

If I understand you ... 

You have the row key = [A,B,C] 
You want to create an inverted mapping of  Key [C] => {[A,B,C]}

That is to say that your inverted index would be all of the rows where the value of C = x
And x is some value. 

You should have to worry about column qualifiers just the values of A , B and C.

In this case, the columns in your index will also be the values of the tuples. 
You really don't need C because you already have it, but then you'd need to remember to add
it to the pair (A, B) that you are storing. 
I'd say waste the space and store (A,B,C) but that's just me. 

Is that what you want to do? 


On Jun 9, 2013, at 12:16 PM, rob mancuso <rcuso123@gmail.com> wrote:

> Thx Anoop, I believe this is what I'm looking for.
> Regarding my use case,  my rowkey is [A,B,C], but i also have a requirement
> to access data by [C] only.  So I'm looking to use a post-put coprocessor
> to maintain one secondary index table where the rowkey starts with [C]. My
> cqs are numerics representing time and can be any number btw 1 and 3600 (ie
> seconds within an hour). Because I won't know the cq value for each
> incoming put (just the cf), I need something to deconstruct the put into a
> list of cqs ...which I believe you've provided with getFamilyMap.
> Thx again!
> On Jun 9, 2013 12:47 AM, "Anoop John" <anoop.hbase@gmail.com> wrote:
>> You want to have an index per every CF+CQ right?  You want to maintain diff
>> tables for diff columns?
>> Put is having getFamilyMap method Map CF vs List KVs.  From this List of
>> KVs you can get all the CQ names and values etc..
>> -Anoop-
>> On Sat, Jun 8, 2013 at 11:24 PM, rob mancuso <rcuso123@gmail.com> wrote:
>>> Hi,
>>> I'm looking to write a post-put observer coprocessor to maintain a
>>> secondary index.  Basically, my current rowkey design is a composite of
>>> A,B,C and I want to be able to also access data by C.  So all i'm looking
>>> to do is invert the rowkey and apply it for all cf:cq values that come
>> in.
>>> My problem (i think), is that in all the good examples i've seen, they
>> all
>>> deconstruct the Put by calling put.get(<cf>,<cq>)...implying they
>> the
>>> qualifier ahead of time.  I'm looking to specify the family and generate
>> a
>>> put to the secondary index table for all qualifiers ...not knowing or
>>> caring what the qualifier is.
>>> Any pointers would be appreciated,
>>> Thx - Rob
>>> Is there a way

View raw message