Got it

Data Warehouse vs Hadoop

Created: Jul 29, 2022 12:09:58Latest reply: Jul 29, 2022 12:14:12 77 1 1 0 0
  Rewarded HiCoins: 0 (problem resolved)

Hello, everyone!

Is Hadoop big data platform better or Data Warehouse better?

Do you have any good advice?

  • x
  • convention:

Featured Answers
olive.zhao
Admin Created Jul 29, 2022 12:14:12

Hello, friend!

The Hadoop big data platform can be regarded as a next-generation data warehousing system. It has the characteristics of modern data warehouses and is widely used by enterprises. Because of the scalability of MPP, the MPP-based data warehousing system is sometimes classified as a big data platform.

However, data warehouses greatly differ from the Hadoop platform in function and user experience in different scenarios. For details, see the following table.

Feature

Hadoop

Data Warehouse

Number of compute nodes

1000s

Max 256

Data volume

Over 10 PB

Max 10 PB

Data type

Relational, semi-relational, unstructured (voice, images, and video)

Relational only

Latency

Medium to high

Low

Application ecosystem

Innovative/AI

Traditional/BI

Application development API

SQL and other programming language APIs, such as MapReduce

Standard database SQL

Scalability

Unlimited, with comprehensive programming APIs

Limited, supported by UDFs

Transaction support

Limited

Comprehensive

Hope this helps!

View more
  • x
  • convention:

All Answers
olive.zhao
olive.zhao Admin Created Jul 29, 2022 12:14:12

Hello, friend!

The Hadoop big data platform can be regarded as a next-generation data warehousing system. It has the characteristics of modern data warehouses and is widely used by enterprises. Because of the scalability of MPP, the MPP-based data warehousing system is sometimes classified as a big data platform.

However, data warehouses greatly differ from the Hadoop platform in function and user experience in different scenarios. For details, see the following table.

Feature

Hadoop

Data Warehouse

Number of compute nodes

1000s

Max 256

Data volume

Over 10 PB

Max 10 PB

Data type

Relational, semi-relational, unstructured (voice, images, and video)

Relational only

Latency

Medium to high

Low

Application ecosystem

Innovative/AI

Traditional/BI

Application development API

SQL and other programming language APIs, such as MapReduce

Standard database SQL

Scalability

Unlimited, with comprehensive programming APIs

Limited, supported by UDFs

Transaction support

Limited

Comprehensive

Hope this helps!

View more
  • x
  • convention:

Comment

You need to log in to comment to the post Login | Register
Comment

Notice: To protect the legitimate rights and interests of you, the community, and third parties, do not release content that may bring legal risks to all parties, including but are not limited to the following:
  • Politically sensitive content
  • Content concerning pornography, gambling, and drug abuse
  • Content that may disclose or infringe upon others ' commercial secrets, intellectual properties, including trade marks, copyrights, and patents, and personal privacy
Do not share your account and password with others. All operations performed using your account will be regarded as your own actions and all consequences arising therefrom will be borne by you. For details, see " User Agreement."

My Followers

Login and enjoy all the member benefits

Login

Block
Are you sure to block this user?
Users on your blacklist cannot comment on your post,cannot mention you, cannot send you private messages.
Reminder
Please bind your phone number to obtain invitation bonus.
Information Protection Guide
Thanks for using Huawei Enterprise Support Community! We will help you learn how we collect, use, store and share your personal information and the rights you have in accordance with Privacy Policy and User Agreement.