Support materialized views

[scsldb]

Description

Support materialized views.

Category

Feature, Performance

Value

TiDB can be used as a real-time data warehouse / create derived datasets, so that analyzing will be more effective.

[stcstc00]

materialized view plz

[li5454yong]

materialized view plz

[CharlesDDDD]

Can materialized views be supported plz!!!!

[sunhao-java]

Can materialized views be supported plz!!!!

[ldzhjn]

CockroachDB already supported this feature in the latest version.
cockroachdb/cockroach@c362707

[darluc]

Anyone knows if itdb compatible with cockroachDB ?

[Al-assad]

Can materialized views be supported plz!!!!

[dveeden]

Note that with changefeeds to Kafka (via TiCDC) you could build this yourself with a process that processes the kafka queue and then updates a table in TiDB. And with KSQL this shouldn't be too hard.

Listening on the Kafka stream could also be used for other things like cache invalidation.

Also note that the best way to show your interest for this is to give a 👍 on the issue description as that makes this show up on this list: https://github.com/pingcap/tidb/issues?q=is%3Aissue+is%3Aopen+sort%3Areactions-%2B1-desc