[feature](ivm) Support incremental view maintenance (IVM) for materialized tables (MTMV) (#62606) ### What problem does this PR solve? Implement Incremental View Maintenance (IVM) for materialized tables (MTMV) in Apache Doris. When a base table of an MTMV changes, only the affected rows are derived from the base-table deltas (row binlog / Table Stream) and transactionally applied to the materialized table, instead of recomputing the whole result with a full refresh. This enables maintaining near-real-time aggregation and join results at a fraction of the cost of full refresh. Supported operators: projection, filter, aggregate (COUNT/SUM/AVG/MIN/MAX, bitmap aggregates, expression arguments, bare GROUP BY, grouping sets), joins (INNER/CROSS/OUTER JOIN, nested join and self join), UNION ALL, subquery aliases, and OneRowRelation. Supported refresh: `REFRESH MATERIALIZED VIEW ... INCREMENTAL/PARTITIONS`, refresh explain, dry-run, and automatic full-refresh fallback when incremental maintenance is not valid (e.g. binlog broken). Lifecycle: stream creation/lifecycle integrated with MTMV, chained IVM MTMV support. This PR is the MTMV incremental-maintenance layer of the end-to-end incremental computation stack tracked by #65418. Issue Number: close #66719 Related issue: #65418 (tracking issue), #57921 (superseded umbrella issue) --------- Co-authored-by: seawinde <wusi@selectdb.com>
English • العربية • বাংলা • Deutsch • Español • فارسی • Français • हिन्दी • Bahasa Indonesia • Italiano • 日本語 • 한국어 • Polski • Português • Română • Русский • Slovenščina • ไทย • Türkçe • Українська • Tiếng Việt • 简体中文 • 繁體中文
Apache Doris is an open-source, real-time analytics and search database built on MPP architecture. It provides fast SQL analytics, lakehouse query acceleration, and hybrid search across structured, text, and vector data.
Explore the official website for the latest product overview, use cases, ecosystem updates, blogs, and user stories. For version updates, see all release notes.
| Use Case | What it provides |
|---|---|
| Customer-Facing Analytics | Ship sub-second interactive analytics to external users. |
| Data Warehousing | Build one real-time warehouse across business domains. |
| Observability | Analyze high-throughput logs, events, and metrics with SQL. |
| Doris for AI | Use vector, text, JSON, and structured search in one SQL engine. |
Apache Doris is built around three core capabilities. The website is the source of truth for detailed product descriptions and examples.
| Capability | What it provides |
|---|---|
| Real-Time Analytics | Streaming ingestion, incremental transformation, and sub-second queries under high concurrency. |
| Lakehouse Analytics | Fast SQL analytics over open table formats such as Iceberg, Delta Lake, and Hudi. |
| Hybrid Search | SQL-native analytics across JSON, full-text, and vector data for AI and search workloads. |
Doris sits at the center of the modern data stack. It connects upstream databases, streaming systems, and lakehouse storage with downstream BI, AI, analytics, and observability tools.
For the latest ecosystem coverage, visit the official website and the connection and integration documentation.
Apache Doris supports both compute-storage coupled and compute-storage decoupled deployments. In decoupled mode, stateless compute groups run over shared object storage, so you can scale compute on demand and isolate workloads.
Learn more in the deployment guide and deployment mode guide.
| Resource | What it provides |
|---|---|
| Community Report | Weekly updates on community activity, merged PRs, contributors, and feature progress. |
| Roadmap 2026 | The 2026 planning discussion for AI and hybrid search, query engine, storage, and data lake work. |
Doris provides connectors and tools for common data engineering workflows.
Apache Doris is used in production by thousands of companies worldwide across internet services, finance, retail, logistics, manufacturing, energy, telecommunications, AI, and other industries.
Apache Doris graduated from the Apache Incubator and became an Apache Top-Level Project in June 2022. Thanks to all community contributors who help build Doris.
Note Some licenses of the third-party dependencies are not compatible with Apache 2.0 License. So you need to disable some Doris features to comply with Apache 2.0 License. For details, refer to the
thirdparty/LICENSE.txt