question

bhakti.dhumal_174748 avatar image
bhakti.dhumal_174748 asked Erick Ramirez edited

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 views
10 |1000
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
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 commented ·

@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 ·