I am having the following data.e
In songs the data is as below:
song_id total_plays 1 2000 2 4532 3 9999 4 2343
And in play event the data is as below:
user_id song_id 102 1 103 4 102 1 102 3 104 2 102 1
For each time a song was played, there is a new entry, even is a song is played again.
With this data I want to :
Get total no. of time each user played each songs. For example, if user_id
102 played, the song_id
1 three times, as per above data. I want to have it grouped by the user_id with total count. Something like below:
user_id song_id count 102 1 3 102 3 1 103 4 1 104 2 1
Can this be done with ElasticSearch via a query instead of having to calculate and store it back to Elastic? I have the flexibility in indexing the data to elastic in any structure, if the structure I followed is wrong or not ideal.