Materialized Views in Hive for Iceberg Table Format
Cloudera
FEBRUARY 8, 2024
We ran the ANALYZE command to gather both table and column statistics on all the base tables. year_total_mv1 ]) The above CBO (cost based optimizer) plan shows that only the year_total_mv1 materialized view is scanned and a filter condition applied since the range filter in the query is a subset of the range in the materialized view.
90 
Let's personalize your content