public RealtimeSummaryStmt(EPAdministrator admin) {
//
// Min,Max,Average total latency from the events (difference in time between A and C) over the
// past 30 minutes.
// Min,Max,Average latency between events A/B (time stamp of B minus A) and B/C (time stamp of C
// minus B).
//
String stmtTotal =
"select min(latencyAC) as minLatencyAC, "
+ "max(latencyAC) as maxLatencyAC, "
+ "avg(latencyAC) as avgLatencyAC, "
+ "min(latencyAB) as minLatencyAB, "
+ "max(latencyAB) as maxLatencyAB, "
+ "avg(latencyAB) as avgLatencyAB, "
+ "min(latencyBC) as minLatencyBC, "
+ "max(latencyBC) as maxLatencyBC, "
+ "avg(latencyBC) as avgLatencyBC "
+ "from CombinedEvent.win:time(30 min)";
totalsStatement = admin.createEQL(stmtTotal);
//
// Min,Max,Average latency grouped by (a) customer ID and (b) supplier ID.
// In other words, metrics on the the latency of the orders coming from each customer and going
// to each supplier.
//
String stmtCustomer =
"select customerId,"
+ "min(latencyAC) as minLatency,"
+ "max(latencyAC) as maxLatency,"
+ "avg(latencyAC) as avgLatency "
+ "from CombinedEvent.win:time(30 min) "
+ "group by customerId";
byCustomerStatement = admin.createEQL(stmtCustomer);
String stmtSupplier =
"select supplierId,"
+ "min(latencyAC) as minLatency,"
+ "max(latencyAC) as maxLatency,"
+ "avg(latencyAC) as avgLatency "
+ "from CombinedEvent.win:time(30 min) "
+ "group by supplierId";
bySupplierStatement = admin.createEQL(stmtSupplier);
}
