hbase-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ryan Rawson <ryano...@gmail.com>
Subject Re: working with versions
Date Mon, 10 May 2010 00:39:41 GMT
The way incrementColumnValue plays with versions is not super clean -
it needs to create new versions at times that are due to technical
necessity not due to business logic.

At SU we have a data scheme where we put the date in the key and then
use incrementColumnValue to keep the column data part up to date.  For
example your year table might have the key '2010' and '2009' only.
For the day you would do something like "2010-05-09'.  And so on.
This makes it both easy to read, easy to sort and fairly clean to
query.

Good luck!
-ryan

On Sun, May 9, 2010 at 11:03 AM, Barney Frank <barneyfranks1@gmail.com> wrote:
> There is a method on the table to increment values:
>
> someHBaseTable.incrementColumnValue()
> Look it up in the javadocs.
>
> On Sun, May 9, 2010 at 10:03 AM, Lior Schachter <liors@infolinks.com> wrote:
>
>> Hi,
>>
>> Suppose I want to keep aggregated data (e.g. counters) per day for a year
>> or
>> so (this way I can query hbase on a specific date range).
>>
>> Is the proper way to do this is to use the in-built versions mechanism of a
>> column i.e. open a new version every day and then when query - sum the
>> right
>> versions values ?
>>
>>
>>
>> Is there an alternative solution,
>>
>>
>>
>> Thanks,
>>
>>
>>
>> Lior
>>
>>
>

Mime
View raw message