Can Cygnus-LD support sending aggregate data (max, min, sum, per hour, per day, etc) to PostgreSQL?

[Emiltzav]

Hello everyone! I'm using Cygnus-LD (Cygnus supporting NGSI-LD) to transfer NGSI-LD data from Orion-LD to PostgreSQL, but they are raw data (not aggregate). I would like to ask If there is a way to make Cygnus-LD send aggregate data (max, min, sum, per hour, per day, etc) to PostgreSQL like Cygnus does with the NGSI-STH Sink (it sends aggregate data to MongoDB from where STH Comet can retrieve them in the form of aggregate data, i.e. statistics such as average, sum, etc). I can't find a parameter (so far) in NGSILDPostgreSQLSink to make this happen.

[fgalan]

Maybe @anmunoz (author of the NGSI-LD support in Cygnus) could provide some feedback on this.

[anmunoz]

Hi,

At this moment the aggregation is not implemented yet. Maybe in a future release, we can include this feature.