Remove 2003 Remove Business Intelligence Remove Metadata Remove Optimization
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. Materialized views can be partitioned on one or more columns.