Which is better for performance? hive 3 or hbase?

Question

I want to save events through Kafka into Hadoop ecosystem and also retrieve them with low latency. I can use hive3 or hbase. Which one should I use?

EricL · Accepted Answer

@ Vinit_Kratin,If low response time is a must, then Hive is not an option, Impala should be faster.HBase designed tables require a row key, which means, all data you want to retrieve will need this key to be queried against HBase. So for your event based data, if you need to use an event id to store and retrieve data, then hbase might be suitable.I still suggest you to go through details of differences between HBase and Hive and Impala to get a better understanding. Google is your friend.CheersEric

EricL · Answer

@Vinit_Kratin,You can't compare Hive with HBase directly, it is really use case dependent. It depends on how you want to store you data, how you will query your data, and whether you need to delete data etc and etc.You will need to explain a bit more on what you want to achieve before an answer can be given as to which is better, hive or hbase.Doing a quick google search returned me below useful links:https://community.cloudera.com/t5/Support-Questions/When-to-use-Hive-and-Hbase/m-p/206167https://community.cloudera.com/t5/Community-Articles/The-Differences-between-Pig-Hive-and-HBase/ta-p/31007https://www.dezyre.com/article/hive-vs-hbase-different-technologies-that-work-better-together/322CheersEric

Sign up

Please use your Cloudera account.

Login to the community

Please use your Cloudera account.