DWS and Hive have different functions in the following aspects:
- Hive is a data warehouse based on Hadoop MapReduce, and DWS is a data warehouse based on Postgres MPP.
- Hive data is stored on HDFS. DWS data can be stored locally or on OBS in foreign table forms.
- Hive does not support indexes. DWS supports indexes, so the query speed is higher.
- Hive does not support stored procedures, but DWS does. Therefore, DWS has more extensive application scenarios.
- DWS supports more SQL statements than Hive, including functions, customized functions, and stored procedures.
- Hive does not support transactions. DWS supports complete transactions.
- Both Hive and DWS support backups, so the reliability is the same.
- DWS delivers much better performance than Hive.
Based on their respective functions, Hive applies only to offline analysis, and DWS applies to online analysis and Ad hoc queries.