Remove 2003 Remove Business Intelligence Remove Metadata Remove Snapshot
article thumbnail

Materialized Views in Hive for Iceberg Table Format

Cloudera

Materialized views are valuable for accelerating common classes of business intelligence (BI) queries that consist of joins, group-bys and aggregate functions. The snapshotId of the source tables involved in the materialized view are also maintained in the metadata. Furthermore, it is partitioned on the d_year column.