There seems to be a contradiction in the docs abou...
# questions-and-troubleshooting
a
There seems to be a contradiction in the docs about refreshing materialized views built on top of catalogs CREATE_MATERIALIZED_VIEW Docs
Currently, StarRocks cannot perceive if the base table data in the external catalog has changed, so all partitions will be refreshed by default every time the base table is refreshed.
Data lake query acceleration with materialized views docs
External table materialized views do not support automatic refresh triggered by base table data changes. They only support asynchronous fixed-interval refresh and manual refresh.
For Hive Catalog, Iceberg Catalog (starting from v3.1.4), JDBC catalog (starting from v3.1.4, only for MySQL range-partitioned tables), and Paimon Catalog (starting from v3.2.1), StarRocks supports detecting data changes at the partition level. As a result, StarRocks can:
• Refresh only the partitions with data changes to avoid full-size refresh, reducing resource consumption caused by refresh.
So how do refreshes work on external catalogs? Can it refresh only partitions where the data has changed or will it refresh everything by default?