Remove 2003 Remove Optimization Remove Snapshot Remove Statistics
article thumbnail

Materialized Views in Hive for Iceberg Table Format

Cloudera

Queries containing joins, filters, projections, group-by, or aggregations without group-by can be transparently rewritten by the Hive optimizer to use one or more eligible materialized views. Subsequently, these snapshot IDs are used to determine the delta changes that should be applied to the materialized view rows.