Remove 2003 Remove Data Lake Remove Statistics Remove Testing
article thumbnail

Materialized Views in Hive for Iceberg Table Format

Cloudera

Performance with materialized views In order to evaluate the performance of queries in the presence of materialized views in Iceberg table format, we used a TPC-DS data set at 1 TB scale factor. We ran the ANALYZE command to gather both table and column statistics on all the base tables.