CODEWITHSUNDEEP
hbasehive
Jesvin Jose
Jesvin Jose

Reputation: 23078

How close is Hbase/Hive to a major RDBMS?

I am looking at Hbase for a schema-less user action store ("user x viewed y", "user x viewed y from page z").

HBase seems a great choice as it

  1. stores data in schema-less format, as well as,
  2. can support complex queries like an RDBMS

Yes, performance considerations come later.

Question 1: What features of an RDBMS will I miss if I use HBase?

If I used an RDBMS, I would use features like SUM, WHERE, GROUP BY, ORDER, BETWEEN, comparisons and (inner) joins; and upto 2NF normalization. Nothing more complex.

Question 2: Apart from the querying, what about:

that are straightforward on an RDBMS?

Upvotes: 0

Views: 417

Answers (1)

Arnon Rotem-Gal-Oz
Arnon Rotem-Gal-Oz

Reputation: 25909

HBase is very far from an RDBMS. Hive lets your write Map/Reduce jobs with SQL-ish syntax but these are still map/reduce jobs.

From your expectations it sounds you should look at sharding solutions over regular RDBMS eg. ScaleDB or ScaleBase

Upvotes: 1

Related Questions