Azure Stream Analytics
An Azure real-time analytics service designed for mission-critical workloads.
342 questions
1 answer
One of the answers was accepted by the question author.
Failed to add Microsoft.StreamAnalyticsJob in Japanese environment
I tried to add new Stream Analytics job on Azure Portal but, it returned an error 404. My Language & Region: setting was Japanese. Once I changed it to English, the error was removed and could create the resource. Because the error has…
asked 2020-09-16T21:20:47.503+00:00
Yusuke Tochigi
56
Reputation points
accepted 2020-09-18T07:04:22.953+00:00
Yusuke Tochigi
56
Reputation points
1 answer
Not getting proper Output of Stream Analytics job in storage account table
Hi, I am trying to capture data using event hub and the output of the stream analytics job is directed to a table in storage account where a 'record' column gets created alongwith some autogenerated timestamp columns. This record column contains only…
asked 2020-08-12T15:57:33.677+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(198.4, 18%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EFS%3C/text%3E%3C/svg%3E)
Francis.S
1
Reputation point
commented 2020-09-08T06:33:30.79+00:00
Sumarigo-MSFT
44,916
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
azure stream analytics query too complex??? not giving proper output and now error... what to do next....
Hi, Query I use attached. I am using an event hub to ingest messages in json format from a push api. Json msg has some arrays in it. Now I am getting an error like "We cannot connect to Event Hub partition [0] because the maximum number of…
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(16, 71%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ER%3C/text%3E%3C/svg%3E)
2 answers
ASA aggregates
Hi, I have a list of sensor values coming in with some details every 10 seconds. I would like to know (on each entering event=10 seconds) what was the last maximum value of the last 60 values. I can make several blocks like below to output one of the…
asked 2020-07-06T15:57:27.253+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(256, 75%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGB%3C/text%3E%3C/svg%3E)
Garrein Bart
1
Reputation point
answered 2020-08-24T08:35:38.303+00:00
Garrein Bart
1
Reputation point
1 answer
One of the answers was accepted by the question author.
Azure stream analytic input from IoT hub
I have a iot solution with iot hub and sql db . so I use stream analytics that integrated in sql db. The problem is: The Input came from iot hub's event endpoint and enriched with iot hub's message enrichment feature. In stream analytic I could get…
asked 2020-08-15T05:06:18.277+00:00
Navid Ahrary
21
Reputation points
accepted 2020-08-15T06:41:14.347+00:00
Navid Ahrary
21
Reputation points
1 answer
Azure Stream Analytics on Edge logging Metrics
Hello, I'm trying to track the output metrics from the azure stream analytics on edge module using the monitoring tools built into the Azure portal. The guides I've found online have this working for the stream analytics in the cloud. Is there any…
asked 2020-07-20T12:58:01.04+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(198.4, 31%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERM%3C/text%3E%3C/svg%3E)
Ryan Maggott
1
Reputation point
commented 2020-08-06T17:29:30.903+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(54.400000000000006, 38%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EQ%3C/text%3E%3C/svg%3E)
QuantumCache
20,186
Reputation points
1 answer
One of the answers was accepted by the question author.
Return two outputs from Azure ML Service in Stream Analytics query
I have an Azure ML webservice that returns a string as an output. Within the string, there are two values that were returned from a model, such as a prediction and the probability associated with the prediction. Since I need both values as an output, I…
asked 2020-07-27T11:22:27.317+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(80, 52%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJH%3C/text%3E%3C/svg%3E)
Justin Hare
21
Reputation points
accepted 2020-07-28T19:43:59.437+00:00
Justin Hare
21
Reputation points
4 answers
Azure Stream Analytics: ML Service function call in cloud job results in no output events
Hey, I've got a problem with an Azure Stream Analytics (ASA) job that should call an Azure ML Service function to score the provided input data. The query was developed und tested in Visual Studio (VS) 2019 with the "Azure Data Lake and…
asked 2020-07-16T16:57:01.43+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(211.20000000000002, 78%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPL%3C/text%3E%3C/svg%3E)
Philipp Lehmann
6
Reputation points
answered 2020-07-18T10:09:45.22+00:00
Philipp Lehmann
6
Reputation points
1 answer
Map Array in Stream Analytics
Is it possible to map an array contained in a message via the geospatial functions? { "id": "<msgid>", "location": {50.2, 30.3}, "geofences": [{"name": xxx, "polygon":…
asked 2020-07-02T10:28:28.27+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(195.2, 34%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EIB%3C/text%3E%3C/svg%3E)
Ingo Busse
1
Reputation point
commented 2020-07-15T18:00:26.773+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(192, 26%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHM%3C/text%3E%3C/svg%3E)
HimanshuSinha-msft
19,376
Reputation points Microsoft Employee
1 answer
Clarification on how to calculate watermark for Azure Streaming Analytics
I'm working on understanding watermarks in Azure Streaming Analytics. Per MS documentation, there are two ways that watermarks can be calculated. …
asked 2020-07-02T14:47:38.423+00:00
Russell Lindell
1
Reputation point
commented 2020-07-13T17:57:39.23+00:00
HimanshuSinha-msft
19,376
Reputation points Microsoft Employee
0 answers
Stream Analytics job - input - error
I'm using IoT hub as input from my stream analytics job however getting following error - There was an error processing the request. Please try again in a few moments. it was working before however after some change in message routing of IoT hub…
asked 2020-07-03T08:13:08.523+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(220.8, 98%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVC%3C/text%3E%3C/svg%3E)
vijay chouhan
6
Reputation points
commented 2020-07-10T16:41:02.647+00:00
HimanshuSinha-msft
19,376
Reputation points Microsoft Employee
1 answer
Azure Streaming Analytics Query: Select latest data only
Hi All, I have very basic SQL experience and i'm a little stuck, so any help is appreciated. I'm working on a way to stream status of some jobs that are running on an HPC resource (sort of like trying to create a dashboard to look at real time flight…
asked 2020-06-17T16:11:53.333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(243.2, 99%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBR%3C/text%3E%3C/svg%3E)
Bhinge, Rahul
1
Reputation point
commented 2020-07-07T18:15:03.867+00:00
HimanshuSinha-msft
19,376
Reputation points Microsoft Employee
2 answers
One of the answers was accepted by the question author.
Stream analytics: C# udf function not found in azure
Hi, I'm creating a stream analytics job with a function, which didn't work. Next I followed this tutorial: https://video2.skills-academy.com/en-us/azure/stream-analytics/stream-analytics-edge-csharp-udf. It runs on my local pc, but when I test it in Azure…
asked 2020-06-17T14:20:23.63+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(160, 23%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EFV%3C/text%3E%3C/svg%3E)
Filip Van Raemdonck
21
Reputation points
commented 2020-06-29T22:24:02.07+00:00
Sander van de Velde | MVP
30,866
Reputation points MVP
2 answers
Azure stream analytics: number in column name
Hi, I have a stream analytics job which outputs to azure table storage. Is it possible to do this when I have a column from which the name contains a numerical value? Regards, Filip Van Raemdonck
asked 2020-06-19T10:03:59.867+00:00
Filip Van Raemdonck
21
Reputation points
answered 2020-06-26T08:33:18.943+00:00
Filip Van Raemdonck
21
Reputation points
2 answers
One of the answers was accepted by the question author.
Does Stream Analytics query support simple binary operators (like + - etc)?
Azure Stream Analytics supports subset of Transaction-SQL and is explained by below document. Stream Analytics Query Language Reference stream-analytics-query-language-reference But I cannot find the simple binary operators (such as +, - etc)…
asked 2020-06-12T05:28:04.683+00:00
bunniesfield
21
Reputation points
answered 2020-06-25T10:05:39.807+00:00
bunniesfield
21
Reputation points
1 answer
One of the answers was accepted by the question author.
Access Nested JSON Array using stream analytics
I am fairly new to stream analytics and I have been trying to parse a nested JSON Array . I need to access the data under collections. The query I am using is as below. I also tried using getarrayelement before collections but that did not work either.…
asked 2020-06-23T23:31:06.03+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(57.599999999999994, 27%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDR%3C/text%3E%3C/svg%3E)
Divyesh Ravichandran
96
Reputation points
accepted 2020-06-24T19:53:34.883+00:00
Divyesh Ravichandran
96
Reputation points
1 answer
How long do videos reside in Microsoft Stream?
Do videos automatically purge after a certain amount of time or do they stay in Microsoft Stream until they are manually deleted. Is there any retention policies available to setup. I am not seeing any place to do that. Thanks, Scott
asked 2020-06-24T16:04:55.643+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(278.4, 16%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBS%3C/text%3E%3C/svg%3E)
Bittinger, Scott E
1
Reputation point
answered 2020-06-24T16:11:02.627+00:00
Dave Patrick
426.4K
Reputation points MVP
1 answer
One of the answers was accepted by the question author.
Data stream between stream analytics services and WebApp service (.NET core 3.1)
Hello All, I and my team are trying to build an app for data visualization and analysis in WebApp the data source is from Stream Analytics Services, can we connect to Stream Analytics from .NET core web app, if there is any way please provide…
asked 2020-06-14T19:13:23.71+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(278.4, 65%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERG%3C/text%3E%3C/svg%3E)
Ranjith Gowda M N
21
Reputation points
commented 2020-06-18T14:20:33.917+00:00
Ranjith Gowda M N
21
Reputation points
1 answer
Access Control Exception on setting data lake storage gen1 as output
Hi, I am receiving JSON data as input of stream analytics job from IOT hub and trying to write it in Data Lake Storage Gen-1. The stream analytics job has read, write and execute permissions and I have read permission to Data Lake storage. According to…
asked 2020-04-19T12:33:39.407+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(64, 48%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETS%3C/text%3E%3C/svg%3E)
Tanishq Singh
21
Reputation points
commented 2020-06-18T11:46:28.45+00:00
PRADEEPCHEEKATLA-MSFT
84,456
Reputation points Microsoft Employee
1 answer
What are the steps to configure a device in iot hub to work with stream analitycs job and can they be viewed in power bi service?
I configured the devices and reached the stage where they are displayed via stream in power bi service, but when turning off the device and turning it on again (obviously following the step of starting azure stream analytics) the data in the displays and…
asked 2020-05-30T18:48:47.27+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(76.8, 63%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESD%3C/text%3E%3C/svg%3E)
Sebastian Domenech
1
Reputation point
commented 2020-06-10T17:46:40.767+00:00
QuantumCache
20,186
Reputation points