Efficient querying of views table
-
Copy to elasticsearch with hourly resolution
{
"resolution": "day",
"@timestamp": 1568627843000,
"entity_urn": "urn:activity:123",
"owner_guid": "456",
"views": 201
}
-
Cli script to run over views and update hourly and update the aggregated number -
Forward plan reducing resolution on main viewstable
Edited by Mark Harding