Are there any cases in the community where TiDB supports materialized views?

Translated
1

Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.

Original topic: 社区中是否有TiDB支持物化视图的案例？

| username: ShawnYan

It was mentioned in the forum that TiDB currently has no plans to support materialized views, and the cdc + flink solution was also mentioned to support materialized views. However, these were posts from a long time ago. I would like to ask the community members if there are any other solutions or third-party tools that support the use of materialized views in TiDB now?

2
| username: Lucien-卢西恩 | Original post link

Hi, Shaw Yan

Currently, the way to provide materialized views is still through TiCDC + Flink to achieve strongly consistent materialized views. There are no known third-party tools or solutions to implement this for now.

The product feature request is still in the pipeline, you can comment your requirements below;

Thank you

3
| username: GreenGuan | Original post link

This feature hasn’t reached GA yet, right?

4
| username: ShawnYan | Original post link

Lucien, thanks,

Considering the migration from Oracle/PG to TiDB, there are cases where materialized views (MV) are used for batch processing in the original database (the data in the MV does not need to be updated in real-time, only periodically), so this question arises. Of course, there may be other usage scenarios as well. It seems that TiDB currently does not natively support MVs.

5
| username: system | Original post link

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.