1 Reply Latest reply: Mar 2, 2017 11:25 AM by Sunny Talwar RSS

    Perform aggregation for IntervalMatch

    Javier Escart�n Ferrer

      I want to obtain the average values for some metrics for some given time intervals.

      I have achieved it using IntervalMatch but my solution does not scale well when  the EventLog grows.

      Is there a way to perform an aggregation (avg, sum,…) within the interval match?

       

      EventLog:

      LOAD * Inline [

      Time, Measurement

      00:00, 0

      01:18, 1

      02:23, 2

      04:15, 3

      08:00, 4

      11:43, 5

      11:44, 5

      11:45, 5

      11:46, 8

      ];

       

      OrderLog:

      LOAD * INLINE [

      Id,Start, End, Order

      1,01:00, 03:35, A

      2,02:30, 07:58, B

      3,03:04, 10:27, C

      4,07:23, 11:43, D

      ];

       

       

      Inner Join IntervalMatch ( Time )

      LOAD Start, End

      Resident OrderLog;

       

      /*

      I don't want to perform all these joins

      */

       

      Inner Join

      LOAD Time, Measurement

      Resident EventLog;

       

      Out:

      LOAD Id,AVG(Measurement) AS mean

      Resident OrderLog

      GROUP BY Id;

       

      Drop Table EventLog;