Is Hadoop OLTP or OLAP?

Is Hadoop good for OLAP?

For transactions and data mining use OLAP. But, for analytics and data discovery use Hadoop. For known cleaned data/processes that yield definitive results of high integrity use OLAP. For unknown messier data/processes that yield suggestive results use Hadoop.

Is Hadoop a transactional database?

One area you would not want to use Hadoop for is transactional data. Transactional data, by its very nature, is highly complex, as a transaction on an ecommerce site can generate many steps that all have to be implemented quickly. That scenario is not at all ideal for Hadoop.

Is Hive OLAP or OLTP?

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.

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.