Stream Analytics job takes several minutes to output results to an Event Hub.
A Stateless Web API Azure Service Fabric application is distributed across 8 nodes. The application is very simple, consisting of a single Controller, which:
Receives a…
I am trying to extract a specific value from an array property in the Stream Analytics query language.
My data looks as follows:
"context": {
"custom": {
"dimensions": [{
"MacAddress": "ma"
},
{
…
I am having an issue in ASA when trying to get the "Max" DateTime.
My code is:
LAST(Timestamp) OVER (PARTITION BY DeviceId LIMIT DURATION(minute, 5)) AS DateTime,
It is coming up with an error saying it is not in an aggregate function or in the…
Hi I wonder if it is possible to select certain items from the array property of a JSON input of Stream Analytics and return them as an array property of a JSON output.
My example to make it more clear - I send a list of OSGI bundles running on a…
I'm trying to build a logic app that inserts data into a Sql database. The data is coming from s Stream Analytics job, outputting it on a Service Bus topic, consumed in Logic Apps in Service Bus trigger.
To populate the properties of the row…
I am streaming data from devices and I want to use the LAG function to identify the last value received from a particular device. The data is not streamed at a regular period and in rare cases it could be days between receiving data from a device.…
My input has a field 'condition' with only two values. Lets assume only values 'A' or 'B'.
When at least a single event with condition=A within a tumbling window is found, only events with condition=A should be outputted. However, when no events for…
I am currently working on Internet Of Things, in my current project I was implemented the logic for to send temperature values to IoT Hub (using Raspberry PI2 and BMP280 sensor), in the azure part I created stream analytics job for receiving the…
I'm getting this error message when configuring my streaming analytics query into my event hub. I'm trying to query for real time data as it arrives into the event hub, so I removed the windowing grouping. I suspect this is what causes this error…
I'm using stream analytics to process some RFID data in realtime. The events from the RFID reader is sending to event hub as an input. Right now I'm facing a problem that the time in events is in UNIX time format, which looks like…
For Blob storage output, how do we control filename? I tried the Path pattern but it only creates the virtual folder in blob. Cannot define the filename in the output.
Example in the path pattern I specified "test" which results in -…
Is there a way to capture and redirect data error events/rows to a separate output?
For example, say I have events coming through and for some reason there are data conversion errors. I would like to handle those errors and do something, probably a…
Is there a Visual Studio template for Stream Analytics job? i.e. a concept of develop and publish from Visual Studio to Azure.
If not how do we develop a application lifecycle for Stream analytics?
For example like Azure Data Factory have json…
I am forwarding events to Azure Event Hub, and I want to process them in Stream Analytics. I have created a new Input that reads from this event hub and outputs to a table storage. When sampling data from the input I get the message:
"No events were…
I've been using StreamInsight for CEP for several months and am interested in moving to ASA. I have a question that I can't answer from the ASA documentation. In StreamInsight I can alter an event's duration to create signal streams from discrete…