question Re: Hive and Hbase : Which is best in terms of storage in Archives of Support Questions (Read Only)

Hive and Hbase : Which is best in terms of storage

amit_dass — Fri, 21 Oct 2016 02:24:05 GMT

As both data resides on hdfs . So which is best in terms of Storage / Memory etc.

Re: Hive and Hbase : Which is best in terms of storage

elserj — Fri, 21 Oct 2016 02:34:47 GMT

Apache Hive and Apache HBase are fundamentally different systems with completely different architectures. As such, which is most efficient really depends on the application use cases. It's impossible to generically state that Hive or HBase is better/worse than the other and the fact that they both use HDFS for storing data is irrelevant.

Please quantify the application requirements you have if you'd like an answer about whether Hive or HBase are better for you.

Re: Hive and Hbase : Which is best in terms of storage

sunile_manjee — Fri, 21 Oct 2016 03:56:24 GMT

I completely agree with josh. hive is best suite for EDW type of querying. HBase is a key value store, so you need to know your questions prior to designing the PDM. Both use HDFS as the underlying storage. If you which queries will be run and have a defined access path model, Phoenix/hbase will provide you lowest latency. If you are looking for general BI queries and can't define access path up front, hive is the way to go.