Materialized view is a pre-computed data set which is one of the most important query performance tuning tools used in Bigdata systems, allowing users to pre-join complex views and pre-compute summaries for quick response time. In CarbonData, materialized views helps in improving performance by doing pre-computation of relevant query projections,filters and expensive operations like aggregations and joins. With materialized views on carbon table, we can avoid unnecessary big-table full-table scans to make query faster.

Read the complete blog here.

  • No labels