Questions tagged [azure-stream-analytics]

Related to Microsoft Azure Cloud Analytics system

Find more information about Azure Stream Analytics:

919 questions
2
votes
0 answers

Azure Stream Analytics to Event Hub Very Slow

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…
2
votes
0 answers

Azure Stream Analytics query language get value by key from array of key value pairs

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" }, { …
user2916547
  • 1,963
  • 5
  • 17
  • 21
2
votes
1 answer

Last DateTime from JSON in Azure Stream Analytics

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…
BrentA
  • 172
  • 8
2
votes
1 answer

Can Stream Analytics filter items of array property?

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…
Milano Nicolum
  • 131
  • 1
  • 6
2
votes
3 answers

Parse Json in Logic App from Stream Analytics -> Service Hub -> Logic Apps

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…
2
votes
1 answer

What is the maximum LIMIT DURATION in the LAG function in ASA?

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.…
Brad
  • 21
  • 2
2
votes
1 answer

Only output events for a condition when at least a single event matching the condition has been found, else output the input

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…
Waaghals
  • 2,029
  • 16
  • 30
2
votes
4 answers

How can I Implement the logic for to send the values of event hub (filtered values by stream analytics job) to IoT Hub using UWP App?

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…
2
votes
1 answer

Exactly One Temporal Window is Expected

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…
acecabana
  • 385
  • 6
  • 16
2
votes
1 answer

Unix time convert to Date in Azure stream analytics

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…
Xinyue Zhao
  • 21
  • 1
  • 3
2
votes
0 answers

Stream Analytics - Blob output filename?

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 -…
databash
  • 656
  • 6
  • 19
2
votes
1 answer

Azure stream analytics - How to redirect or handle error events/rows?

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…
databash
  • 656
  • 6
  • 19
2
votes
3 answers

Visual Studio template for Stream Analytics job?

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…
databash
  • 656
  • 6
  • 19
2
votes
2 answers

No events were found for the specified time range

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…
2
votes
1 answer

Moving to Azure Stream Analytics from StreamInsight

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…
Graeme Wilson
  • 130
  • 1
  • 2
  • 7