Is Hadoop good for OLAP?

Question

OLAP on Hadoop solves the problems of speed and scale associated with Big Data. It involves creating multi-dimensional cubes on massive volumes of data using the unlimited storage and processing power of Hadoop. These cubes can serve complex queries instantly and enable quick analysis of Big Data. 13 июн. 2019 г.

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

Is Hive suitable for OLAP?

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.

Which database is used for OLAP?

The core of most OLAP databases is the OLAP cube, which allows you to quickly query, report on and analyze multidimensional data.

Is HBase OLAP or OLTP?

HBase (a NoSQL variant) is designed to be an OLTP engine, allowing an architecture of high-volume transactional operations – think messaging platforms with constant messages being exchanged between users or transactions being generated in a financial system.

Expert · Answer