azure-stream-analytics | Azure Stream Analytics | Azure library

After using the CollectTop aggregation function of Azure Stream Analytics, I get back a json-like structure that seems to be like a Dictionary of Dictionaries. I need to convert this one to a multi-dimensional array which I want to pass to an AzureML UDF.

My question is mostly on how I can interpret this structure in a javascript-UDF, as I'm totally new to Javascript.

This is a sample record (using CollectTop), but the challenge is how my javascript UDF should look like?

I'm working on understanding watermarks in Azure Streaming Analytics. Per MS documentation, there are two ways that watermarks can be calculated.

https://docs.microsoft.com/en-us/azure/stream-analytics/stream-analytics-time-handling#how-time-progresses-in-azure-stream-analytics

The second method states: "When there's no incoming event, the watermark is the current estimated arrival time minus the late arrival tolerance window. The estimated arrival time is the time that has elapsed from the last time an input event was seen plus that input event's arrival time."

Questions:

• What is meant by "No incoming events"? Does this mean that the source (ex. Event Hub) is verified to be empty?

• What is meant by "The last time an input event was seen."? Does this mean when it has exited the processing engine to the source?

Currently, this is how I interpret the calculation: (7) Watermark = (5) [Estimated Arrival Time] - (6) [Late Arrival Tolerance Window]

(5) Estimated Arrival Time = (1) [Elapsed Time] + (4) [Last Arrival Time]

(1) Elapsed Time = Time that elapsed from the (2) [Last time an input event was last seen] and (3) [the current time]

I have the following query which combines events from two inputs.

i'm doing the polar bear training module (https://docs.microsoft.com/de-de/learn/modules/build-ml-model-with-azure-stream-analytics/11-connect-db-and-function) from MS.

I have a MSDN Subs, in this case i can't create a DB in the same location like my other Resources.

In the 11th Step in the tutorial i connected my DB with the job, but i don't get any results in my DB after running the job for 5 min. (

Any suggestions?

I have 2 questions:

1. Does azure Stream analytics support nested conditions using the CASE statement ?
2. I see there are 2 formats of CASE expression mentioned here- https://docs.microsoft.com/en-us/stream-analytics-query/case-azure-stream-analytics . I found examples for searched CASE here. Can anyone give example for the Simple CASE expression?

Resuming what I'm looking for to do with Apache Beam in Google Dataflow is something like LAG in the Azure Stream Analytics

Using a window of X minutes where I'm receiving data:

I have written below Stream Analytics Query to get Device Offline status alert. Query gives me an alert if no input received from device in the last 5 minute.

I need last telematic record (Last known location) of that device, but I'm getting all data sent for that device. I tried LAST and TopOne but all are windowing method. Is there any other solution than a custom function?

How can I define an overlapping tumbling window as EPL query in Esper? I'm looking for equivalent of hopping windows similar to these:

https://docs.microsoft.com/en-us/stream-analytics-query/hopping-window-azure-stream-analytics

For example: 1 second hopping window with 500ms overlap.

Esper's reference manual describes tumbling windows and overlapping context, but how can I express it as a query?

Thank you.

IoT Edge v2 with the modbus module sends data to IoT Hub in the format of: