Examples of how to Implement counter columns?

[dan-mi-sun]

This is an extension to this question:

http://stackoverflow.com/questions/37236128/how-to-increment-cassandra-counter-column-with-phantom-dsl

This question has also been asked here.

In Thiagos example the two tables; 'songs' & 'songs_by_artist' both have the same rows but with different partitions (primary keys / clustering columns)

CREATE TABLE test.songs (
    song_id timeuuid PRIMARY KEY,
    album text,
    artist text,
    title text
);

CREATE TABLE test.songs_by_artist (
    artist text,
    song_id timeuuid,
    album text,
    title text,
    PRIMARY KEY (artist, song_id)
) WITH CLUSTERING ORDER BY (song_id ASC);

This means inserting, updating and deleting across both tables within the SongsService works with the same base data / rows.

How would you for example have a table such as 'artist_songs_counts', with columns 'song_id' (K) and 'num_songs' (++) and ensure that 'SongsService' adds corresponding row to each table; 'songs' & 'songs_by_artist' & 'artist_songs_counts' (where there are different numbers of row but information should be linked, such as the artist info).

CREATE TABLE test.artist_songs_counts (
    artist text PRIMARY KEY,
    num_songs counter);

[iamthiago]

I have answered your question on SO http://stackoverflow.com/questions/37245031/how-to-implement-cassandra-counter-columns-with-phantom-dsl/37256783#37256783 take a look and if that fits what you need, please close this issue.

[dan-mi-sun]

thanks @thiagoandrade6