Why is Hive not good for OLTP

–1 vote
I have read in lots of blogs and PPTs and discussions that Hive is not good for OLTP. But because of it's distributed feature, I thought it would be better to use Hive for OLTP such as banking systems. Why do people tell it is not good?
Jan 7, 2019 in Big Data Hadoop by digger
 • 26,740 points • 6,479 views

1 answer to this question.

0 votes

Apache Hive is mainly used for batch processing i.e. OLAP and it is not used for OLTP because of the real-time operations of the database. 

Instead, hbase is extensively used for transactional processing wherein the response time of the query is not highly interactive i.e. OLTP. Unlike Hive, operations in HBase are run in real-time on the database instead of transforming into MapReduce jobs.

You can even check out the details of Big Data with the DP-203 Certification Course

answered Jan 7, 2019 by Omkar
 • 69,220 points

Related Questions In Big Data Hadoop

0 votes
1 answer

Why is HDFS used for the applications with large data sets, and not for the multiple small files?

HDFS is more efficient for a large ...READ MORE

answered Dec 19, 2018 in Big Data Hadoop by Neha
 • 6,300 points • 5,584 views
+1 vote
2 answers

Sir if i have no knowledge of any programming language then it is good or bad for me but i have learned Big Data and Hadoop so i can get a job or not

Hey Rahul,  You have mentioned that you have no ...READ MORE

answered May 6, 2019 in Big Data Hadoop by poonam
 • 1,479 views
0 votes
1 answer

Why Max is throwing in below query in hive for alias?

Hi, You can do one thing, just enclose ...READ MORE

answered May 17, 2019 in Big Data Hadoop by reshma
 • 853 views
0 votes
1 answer

Is there a good online tutorial for Hadoop development on a Windows 7 machine?

I would suggest you go through this ...READ MORE

answered Mar 29, 2018 in Big Data Hadoop by kurt_cobain
 • 9,350 points • 689 views
+1 vote
1 answer

Hadoop Mapreduce word count Program

Firstly you need to understand the concept ...READ MORE

answered Mar 16, 2018 in Data Analytics by nitinrawat895
 • 11,380 points • 11,028 views
0 votes
1 answer

hadoop.mapred vs hadoop.mapreduce?

org.apache.hadoop.mapred is the Old API  org.apache.hadoop.mapreduce is the ...READ MORE

answered Mar 16, 2018 in Data Analytics by nitinrawat895
 • 11,380 points • 2,536 views
+2 votes
11 answers

hadoop fs -put command?

Hi, You can create one directory in HDFS ...READ MORE

answered Mar 16, 2018 in Big Data Hadoop by nitinrawat895
 • 11,380 points • 108,832 views
–1 vote
1 answer

Hadoop dfs -ls command?

In your case there is no difference ...READ MORE

answered Mar 16, 2018 in Big Data Hadoop by kurt_cobain
 • 9,350 points • 4,612 views
0 votes
1 answer

Hadoop MapReduce wordcount "type job is not applicable for the arguments" error

The combiner class is not required in ...READ MORE

answered Dec 19, 2018 in Big Data Hadoop by Omkar
 • 69,220 points • 824 views
0 votes
1 answer

Why is using Combiner function not preferred in shuffling?

Combiner function is not preferred because when ...READ MORE

answered Jan 23, 2019 in Big Data Hadoop by Omkar
 • 69,220 points • 775 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP
"PMP®","PMI®", "PMI-ACP®" and "PMBOK®" are registered marks of the Project Management Institute, Inc. MongoDB®, Mongo and the leaf logo are the registered trademarks of MongoDB, Inc.