Remove 2003 Remove Business Intelligence Remove Optimization Remove Statistics
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. We ran the ANALYZE command to gather both table and column statistics on all the base tables. Materialized views can be partitioned on one or more columns.