Transpose CSV data from Eventhub RRS feed

  • Question

  • I'm trying to take wide CSV data from an old on-premises system that contains multiple metrics on each row through EventHub, and use Streaming analytics to create a summarised row per metric in order to correctly drive the PowerBI visuals.  The fall back is a much more complex pipeline.

    example CSV row:

    date, metric1, metric2, metric3...

    required aggregated HoppingWindow output to drive powerBI:

    date window, "metric type1", sum(metric1)

    date window, "metric type2", sum(metric2)

    Thursday, August 3, 2017 1:23 PM

All replies

  • Hi,

    You can try a query like this:

    SELECT SUM(metric1) as Metric_Type1, SUM (metric2) as  Metric_Type2
    FROM input
    GROUP BY TumblingWindow(hour,1)

    However the definition of the window will depend how when you start the job. Let me know if it works for you.



    Tuesday, August 15, 2017 9:00 PM