hbase-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From anil gupta <anilgupt...@gmail.com>
Subject Re: HBase and Datawarehouse
Date Mon, 29 Apr 2013 05:21:09 GMT
Hi Kiran,

In HBase the data is denormalized but at the core HBase is KeyValue based
database meant for lookups or queries that expect response in milliseconds.
OLAP i.e. data warehouse usually involves heavy data crunching. HBase is
not really intended for heavy data crunching. If you want to just store
denoramlized data and do simple queries then HBase is good. For OLAP kind
of stuff, you can make HBase work but IMO you will be better off using Hive
for  data warehousing.

HTH,
Anil Gupta


On Sun, Apr 28, 2013 at 8:39 PM, Kiran <kiranvk2011@gmail.com> wrote:

> But in HBase data can be said to be in  denormalised state as the
> methodology
> used for storage is a (column family:column) based flexible schema .Also,
> from Google's  big table paper it is evident that HBase is capable of doing
> OLAP.SO where does the difference lie?
>
>
>
> --
> View this message in context:
> http://apache-hbase.679495.n3.nabble.com/HBase-and-Datawarehouse-tp4043172p4043216.html
> Sent from the HBase User mailing list archive at Nabble.com.
>



-- 
Thanks & Regards,
Anil Gupta

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message