Is Hive suitable for OLAP?

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 г.

Can Hive be used in OLTP system?

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

Is Hadoop used for OLAP?

Hadoop is an OLAP. Hadoop is neither OLAP nor OLTP. All above are true statements. Since we use Hadoop to process the analysis of big data & this is done by batch wise on historical data which is loaded in the HDFS (Hadoop distributed file system).

What is Hive good for?

Hive allows users to read, write, and manage petabytes of data using SQL. Hive is built on top of Apache Hadoop, which is an open-source framework used to efficiently store and process large datasets. As a result, Hive is closely integrated with Hadoop, and is designed to work quickly on petabytes of data.

Which database is used by Hive?

For single user metadata storage, Hive uses derby database and for multiple user Metadata or shared Metadata case Hive uses MYSQL.

Expert · Answer