hey friends one question for the community! do you think Pinot would be a good solution to show the realtime views of a page… like say currently there are x users seeing your page, or would that be more like a cache solution like redis

Do you want to display the actual users or just count? Also, do you want to provide drill down along other dimensions-geo, browser etc

just the count of users, like which products are being watched in realtime but I'm thinking maybe redis is a better solution for it too given that it's only the count so don't know when Pinot may come into play only if we look into any dimensions but only realtime

well, if you are trying to find the top products being watched in real-time then thats analytics but if we are trying to simply query how many are looking at this page (a simple key value based access) then Redis will be the right solution