https://pinot.apache.org/ logo
#general
Title
# general
l

Lakshmanan Velusamy

07/20/2021, 6:20 AM
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 ?
k

Kishore G

07/20/2021, 6:26 AM
using upsert feature, you should be able to solve both
other approach is to have two tables - one upsert enabled and the other append only mode
l

Lakshmanan Velusamy

07/20/2021, 7:00 AM
Could you elaborate more ? How can upsert solve this ? These are discrete events periodically emitted by the entity.
m

Mayank

07/20/2021, 1:24 PM
@User you can find more here details https://docs.pinot.apache.org/basics/data-import/upsert
👍 1
l

Lakshmanan Velusamy

07/20/2021, 4:24 PM
Thanks @User, let me explore on this.
👍 1