Is Hive a OLTP?

Question

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. 7 янв. 2019 г.

Does Hive support OLTP?

No Hive does not provide insert and update at row level. So it is not suitable for OLTP system.

Is Hive an OLAP?

As discussed in Carter Shanklin's great blog post, it should be noted that the Hive/Druid integration alone is not an OLAP platform, per se. For example, while Hive provides a SQL query interface to Druid tables, most enterprise class OLAP solutions need to support the MDX (multi-dimensional expression) query language.

Is Hive a relational database?

No, we cannot call Apache Hive a relational database, as it is a data warehouse which is built on top of Apache Hadoop for providing data summarization, query and, analysis. It differs from a relational database in a way that it stores schema in a database and processed data into HDFS.

What is an OLTP database?

OLTP (Online Transaction Processing) is a data processing category that deals with numerous transactions performed by many users. The OLTP system is an online database system that processes day-to-day queries that usually involve inserting, updating, and deleting data.

Expert · Answer