Hi Community, We have a table that records events emitted by an entity (timestamp, entity_id, status (OPEN/CLOSED)). Events are sparse, emitted only when there is a state change. We want to compute at any given point in time, how many entities are open (also want to track the trend, in a time range plot the trend of # of entities open). Are there any time series functions to help with this ?

using upsert feature, you should be able to solve both

Could you elaborate more ? How can upsert solve this ? These are discrete events periodically emitted by the entity.

@User you can find more here details https://docs.pinot.apache.org/basics/data-import/upsert

Thanks @User, let me explore on this.