Hi N1QL World,
I’m not a developer-rather a designer who wants to get some insights.
as sessions run in millions per day, I don’t want to store data unnecesarily.
I want to record some transactions in a new data store, say data store1. this contains daily details of sessions and subscriber msisdn. So store1 looks like this - date-time, sessionid and msisdn.
I want to run a job(job1) every night to derive unique count of sessionid and unique count of msisdn.
I want to store the result to second store- date-time, count(sessionid), count(msisdn).
Then a second job(job2) runs every month to get sum of session id and sum from msisdn.
I’m looking for N1QL efficient query for job1 and job2 for above scenario as today date/calendar month is constantly changing.