Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
HBase >> mail # user >> HBase and Datawarehouse

Copy link to this message
Re: HBase and Datawarehouse

On Sun, Apr 28, 2013 at 10:40 PM, Kiran <[EMAIL PROTECTED]> wrote:

> Anil,
> So it means HBase can help in easy retrieval and insertions on large
> volumes
> of data but it lacks the power to analyse and summarize the data?

Out of the box, it can do simple aggregations like sum, avg, etc. But, if
you have complex analytical queries(lead, lag rolling aggregates) then you
can write your Coprocessor for doing those analytical queries.

> In HBase
> can't we write Map-Reduce jobs that can do this "data cunching"?

Yes you can do. But, if you are only going to do MR then why use HBase for
storing data?

> As per your
> analysis isn't that a feasible approach than the data warehousing systems?
I dont know your use case in detail so cant say whether it will work for
you or not. But, theoretically it is feasible. Have you evaluated hive/pig
for data warehousing?

> --
> View this message in context:
> http://apache-hbase.679495.n3.nabble.com/HBase-and-Datawarehouse-tp4043172p4043220.html
> Sent from the HBase User mailing list archive at Nabble.com.

Thanks & Regards,
Anil Gupta