Bringing together the Apache Cassandra experts from the community and DataStax.

Want to learn? Have a question? Want to share your expertise? You are in the right place!

Not sure where to begin? Getting Started

 

question

bhakti.dhumal_174748 avatar image
bhakti.dhumal_174748 asked pankajgajjar_39995 commented

Are Materialized Views in C* 3.11, 4.0 stable?

Hello, 
concern about Materialized Views (MVs) in Cassandra. Unfortunately starting with version 3.11, MVs are officially considered experimental and not ready for production use, as you can read here: 
http://mail-archives.apache.org/mod_mbox/cassandra-user/201710.mbox/%3CetPan.59f24f38.438f4e99.74dc@apple.com%3E
 Can you please someone give some productive feedback on this ? it would help us to further implementation around the MVs in Cassandra. 
Does anyone facing some critical issue or data lose or synchronization issue ? 
Regards
Bhakti
materialized viewsmv
10 |1000 characters needed characters left characters exceeded
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 8 attachments (including images) can be used with a maximum of 1.0 MiB each and 10.0 MiB total.

1 Answer

Erick Ramirez avatar image
Erick Ramirez answered pankajgajjar_39995 commented

@bhakti.dhumal_174748 There are still some issues with materialized views so they are still not recommended for production use. See NEWS.txt on Github for more info.

Note that Apache Cassandra 4.0 has not been released yet. Cheers!

1 comment Share
10 |1000 characters needed characters left characters exceeded
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 8 attachments (including images) can be used with a maximum of 1.0 MiB each and 10.0 MiB total.

pankajgajjar_39995 avatar image pankajgajjar_39995 ·

@Erick Ramirez what is alternative of MVs? below approach?

  1. Query-based Table : (Recommended as per the complete Cassandra guideline )
    1. This would be the scenario base query table and this has to update by the application.
  2. Use Master Table Only :
    1. This would be the main table that would store all the master data and base on need, put SSI on the column field and fire the query.
0 Likes 0 ·