FunnelCake definition for basic web log analysis using BrightContext

web-log-processing-example.cake

INPUT requests;

// example: { action: 'GET', path: '/', code: 200 }

OUTPUT requestmetrics;

// send out the number of requests in that window every 5 seconds

requestmetrics = GROUP requests
  BY TIMEONLY
  SAMPLERATE 5
  AGG FC.count("5SEC") AS requestCount, // the current real-time count
      FC.count("ALL") AS totalCount;    // the all time count, cumulative