Why it matters

Views enable reuse. Understanding types shapes performance + freshness trade-offs.

Advertisement

The architecture

Virtual view: metadata only. Substituted at query time.

Materialized view: physical table with cached results.

Hive view typesVirtual viewlogical rewriteMaterialized viewcached physicalRefresh policymanual or autoMaterialized views enable query rewriting: optimizer redirects matching queries
View types.
Advertisement

How it works end to end

Materialized view refresh: on demand, incremental, or scheduled.

Query rewriting: optimizer uses materialized views for queries matching semantics.

Cost: MV stores extra data, refreshes cost compute.

Freshness: MV can be stale until refresh.