Materialized Views in Hive for Iceberg Table Format
Cloudera
FEBRUARY 8, 2024
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. Overall, across all queries, the average reduction in total elapsed time was 40%.
Let's personalize your content