Page History

...

Materialized View is integrated as a DataMap in CarbonData, it provides pre-aggregation for SPJGH. Comparing to "preaggregate" DataMap introduced in version 1.3.0, it covers more scenario for OLAP application. Currently, it supports SPJGH-like table (select-predicate-join-groupby-having) .  User can use existing DataMap statement to and user can follow existing DataMap statement (similar to CTAS statement) to  create, drop, show Materialized Viewsthem. While querying, system finds good MVs based on cost for query rewrite to improve query performance. As an initial release of this feature, while we encourage user to try and test, it still has some limitation and will be improved in coming release.  

Enhancement for Detail Record Analysis

...