Re: Materialized View inconsistency issue

[C. Scott Andreas]

That’s correct, yes. There is no current or upcoming version of Apache Cassandra in which materialized views are expected to be considered production-ready and maintain full consistency with their base table at this time. The feature is classified as “experimental” to indicate that this behavior is unfortunately expected. Upcoming features such as distributed transactions may simplify the process of maintaining consistent materialized views from the perspective of an application in a future release. - Scott On Aug 8, 2023, at 10:10 PM, manish khandelwal <manishkhandelwa...@gmail.com> wrote:  From 4.0.11's cassandra.yaml  ######################### # EXPERIMENTAL FEATURES # ######################### # Enables materialized view creation on this node. # Materialized views are considered experimental and are not recommended for production use. enable_materialized_views: false So I think they have to be used with care and clear understanding of the functionality only. Otherwise it is better to avoid them. Regards Manish On Wed, Aug 9, 2023 at 2:06 AM Surbhi Gupta <surbhi.gupt...@gmail.com> wrote: Hi, We get complaints about Materialized View inconsistency issues. We are on 3.11.5 and on 3.11.5 Materialized Views were not production ready. We are ok to upgrade. On which version of cassandra MVs doesnt have inconsistency issues? Thanks Surbhi