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.

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 <[EMAIL PROTECTED]>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.
>

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 <[EMAIL PROTECTED]>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.
>