You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@hbase.apache.org by Oleg Ruchovets <or...@gmail.com> on 2013/01/16 11:23:30 UTC

hbase olap cube

Hi ,

    I have a timeseries data  and I am looking for capabilities to store
and aggregates the events on such level granularity:   YEAR | MONTH  | WEEK
| DAY  | HOUR.
I need functionality like sum() , average().
For example to calculate average for event X which was at 14:00 PM every
sunday during JANUARY.

Questions:
    1) I see it like Olap Cube solution , Am I right?
    2) Can someone point me on  Olap Cube open source project over hbase?

Thanks
Oleg.

Re: hbase olap cube

Posted by Amit Sela <am...@infolinks.com>.

Hi Oleg,

Try this  http://github.com/urbanairship/datacube
Andrew Purtell recommended it here when I had a similar need. I didn't need
things like sum and average so I ended up using a RegionObserver
coprocessor but I did take a look and looks like it might help you.

Good Luck!

On Wed, Jan 16, 2013 at 12:23 PM, Oleg Ruchovets <or...@gmail.com>wrote:

> Hi ,
>
>     I have a timeseries data  and I am looking for capabilities to store
> and aggregates the events on such level granularity:   YEAR | MONTH  | WEEK
> | DAY  | HOUR.
> I need functionality like sum() , average().
> For example to calculate average for event X which was at 14:00 PM every
> sunday during JANUARY.
>
> Questions:
>     1) I see it like Olap Cube solution , Am I right?
>     2) Can someone point me on  Olap Cube open source project over hbase?
>
> Thanks
> Oleg.
>

Re: hbase olap cube

Posted by Otis Gospodnetic <ot...@gmail.com>.

Hi,

There is one getting started on Github.  Also google for HBase lattice.

We've also built something like that at Sematext, with real-time in memory
agg and HBase persistence (we use it for the thing in my sig and more), but
have not OSSed it.

Otis
--
HBASE Performance Monitoring - http://sematext.com/spm/index.html

On Wed, Jan 16, 2013 at 5:23 AM, Oleg Ruchovets <or...@gmail.com>wrote:

> Hi ,
>
>     I have a timeseries data  and I am looking for capabilities to store
> and aggregates the events on such level granularity:   YEAR | MONTH  | WEEK
> | DAY  | HOUR.
> I need functionality like sum() , average().
> For example to calculate average for event X which was at 14:00 PM every
> sunday during JANUARY.
>
> Questions:
>     1) I see it like Olap Cube solution , Am I right?
>     2) Can someone point me on  Olap Cube open source project over hbase?
>
> Thanks
> Oleg.
>