Accumulation of materialized views in Cassandra.
Hi as I am new to Cassandra. I read some books, documents and blog posts to get to know them. Now I would like to get an answer to the question of how to implement "Accumulation of Materialized Views in Cassandra" and what I mean is: Suppose we have the following Game model {userId, gameName, time, gameMoney .... etc. } If I want to "Aggregate" games by userId, gameName, I will need to denormalize the table to some materialized view, where the same data is stored, but in a different model.
What I want is when any record is inserted into the first table, the record is inserted into the materialized view, or it is updated and accumulated if it exists.
For example:
Game { 1,gameOne,12:00,1.2}
Game {1, gameTwo, 12:00, 2.3}
Game {1,gameTwo,11:00, 2.3}
In denormalized materialized view, I want to have two entries (aggregation by username and gamename) that looks like
UserGames { 1,gameOne,1.2 }
UserGames {1,gameTow, 4.6 }
I know about triggers, but I'm curious if there are other ways to do this?
source to share
The aggregation of materialized views is still not implemented. Here is the corresponding Jira ticket and aggregates .
source to share