I received quite a number of follow up questions directly as a result of my
response to Tobias' question. My comments on MVs specifically only relate
to MVs in OSS C*. :)
I'd like to reiterate that my responses to this mailing list are almost
exclusively relating to OSS C* but I'm going to make an
Hi Tobias,
I have had a similar experiences to Jon where I have seen Materialized
Views cause major issues in clusters. I too recommend avoiding them.
Regards,
Anthony
On Sat, 29 Feb 2020 at 07:37, Jon Haddad wrote:
> I also recommend avoiding them. I've seen too many clusters fall over as
>
I have had some serious issues with MVs in production - I would
recommend not using them.
On Fri, 28 Feb 2020 at 22:34, Erick Ramirez
wrote:
> Personally, I think MVs are still experimental and not ready for
> primetime. It works for some but if you run into issues, fixing them have a
> huge imp
Personally, I think MVs are still experimental and not ready for primetime.
It works for some but if you run into issues, fixing them have a huge
impact to your application. For example if the view updates get too far
behind, there's no effective way to resolve them other than having to drop
the MV
been significant work done here to improve or even solve
the problems
-Tobias
From: Jon Haddad
Reply to: "user@cassandra.apache.org"
Date: Friday, 28 February 2020 at 21:37
To: "user@cassandra.apache.org"
Subject: Re: Should we use Materialised Views or ditch them ?
I also rec
I also recommend avoiding them. I've seen too many clusters fall over as a
result of their usage.
On Fri, Feb 28, 2020 at 9:52 AM Max C. wrote:
> The general view of the community is that you should *NOT* use them in
> production, due to multiple serious outstanding issues (see Jira). We used
The general view of the community is that you should *NOT* use them in
production, due to multiple serious outstanding issues (see Jira). We used
them quite a bit when they first came out and have since rolled back all uses
except for the absolute most basic cases (ex: a table with 30K rows th
Hi
A debate has surfaced in my company, whether to keep or remove Materialized
Views
The Datastax FAQ says sure thing, go ahead and use it
https://docs.datastax.com/en/dse/5.1/cql/cql/cql_using/faqMV.html
But know the limitations
https://docs.datastax.com/en/dse/5.1/cql/cql/cql_using/knownLimitat