Hi Hannu, There are more than a few committers that don't think MVs are currently suitable for production use. I'm not involved with MV development, so this may not be 100% accurate, but the problems as I understand them are:
There's no way to determine if a view is out of sync with the base table. If you do determine that a view is out of sync, the only way to fix it is to drop and rebuild the view. There are liveness issues with updates being reflected in the view. Any one of these issues makes it difficult to recommend for general application development. I'd say that if you're not super familiar with their shortcomings and are confident you can fit your use case in them, you're probably better off not using them. Thanks, Blake On October 2, 2017 at 6:55:52 AM, Hannu Kröger (hkro...@gmail.com) wrote: Hello, I have seen some discussions around Materialized Views and stability of that functionality. There are some open issues around repairs: https://issues.apache.org/jira/browse/CASSANDRA-13810?jql=project%20%3D%20CASSANDRA%20AND%20issuetype%20%3D%20Bug%20AND%20status%20in%20(Open%2C%20%22In%20Progress%22%2C%20Reopened%2C%20%22Patch%20Available%22%2C%20Testing%2C%20%22Ready%20to%20Commit%22%2C%20%22Awaiting%20Feedback%22)%20AND%20component%20%3D%20%22Materialized%20Views%22 Is it so that the current problems are mostly related to incremental repairs or are there also other major concerns why some people don’t consider them to be safe for production use? Cheers, Hannu
