I've been dealing with MV extensively, and I second Blake. MVs are not suitable for production. Unless you're ready for the pain (The out of sync is a major pain point), I would not go that way.
Regards, Carlos Juzarte Rolo Cassandra Consultant / Datastax Certified Architect / Cassandra MVP Pythian - Love your data rolo@pythian | Twitter: @cjrolo | Skype: cjr2k3 | Linkedin: *linkedin.com/in/carlosjuzarterolo <http://linkedin.com/in/carlosjuzarterolo>* Mobile: +351 918 918 100 www.pythian.com On Mon, Oct 2, 2017 at 4:50 PM, Blake Eggleston <beggles...@apple.com> wrote: > 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 > > -- --
