Azure Stream Analytics
An Azure real-time analytics service designed for mission-critical workloads.
330 questions
1 answer
ASA: Encountered error when communicating with EventHub: Exceeded the maximum number of allowed receivers per partition in a consumer group which is 5
https://stackoverflow.com/questions/74305395/exceeded-the-maximum-number-of-allowed-receivers-azure-stream-analytics-job-con I have read and followed the suggestion from the link above but the ASA still throws me the same error so I made some…
asked 2023-09-12T02:28:07.35+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(0, 75%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECI%3C/text%3E%3C/svg%3E)
Chiu I Keanu Leung
0
Reputation points
commented 2023-10-31T07:59:07.9633333+00:00
Chiu I Keanu Leung
0
Reputation points
1 answer
WebApp Stream logs not showing in Logs table AppServiceConsoleLogs
Hello, we have a linux WebApp, we have some logging that we can see in the Stream logs, but I can not see the logs in the AppServiceConsoleLogs table (is empty). Can somebody help with the issue?
asked 2023-10-25T10:41:54.38+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(28.799999999999997, 65%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVL%3C/text%3E%3C/svg%3E)
Virginia Lopez - External
0
Reputation points
commented 2023-10-31T03:54:29.6333333+00:00
brtrach-MSFT
15,251
Reputation points Microsoft Employee
1 answer
Azure Stream analytics map column when writing parquet files
I was trying to use the capture feature for eventhub, writing Parquet files to blob storage. The UI passed me for creating a Azure Stream Analytics. I have a Json structure in the eventhub, which contains an object field, like the…
asked 2023-10-19T10:42:05.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(192, 83%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EES%3C/text%3E%3C/svg%3E)
Eran Shemesh
0
Reputation points Microsoft Employee
commented 2023-10-30T10:59:55.2466667+00:00
PRADEEPCHEEKATLA-MSFT
77,086
Reputation points Microsoft Employee
1 answer
Stream Analytics job is lock
Hi, my SAJ is blocked, not working, I can't see inputs, outputs or query. The controls on the main service page (Start job; Delete; Move) are disabled. What could be wrong? Thanks JD
asked 2023-10-20T08:37:27.46+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(300.8, 71%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJD%3C/text%3E%3C/svg%3E)
Jaroslav Dyrčík
0
Reputation points
answered 2023-10-20T11:21:01.41+00:00
Sander van de Velde
28,386
Reputation points MVP
1 answer
One of the answers was accepted by the question author.
Stream analytics
The Stream Analytics job works, it's just that it does not show in the Cosmos DB container. I am not sure whether it is my partition key that is incorrect.
asked 2023-10-19T20:29:16.98+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(0, 50%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGM%3C/text%3E%3C/svg%3E)
Given Mnisi
40
Reputation points
accepted 2023-10-19T22:57:34.4866667+00:00
Given Mnisi
40
Reputation points
1 answer
One of the answers was accepted by the question author.
Azure stream analytics
I get this error when I want to display the data generated from this script
Azure Event Hubs
Azure Event Hubs
An Azure real-time data ingestion service.
557 questions
Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
4,608 questions
Azure Stream Analytics
Azure Stream Analytics
An Azure real-time analytics service designed for mission-critical workloads.
330 questions
Azure Cosmos DB
Azure Cosmos DB
An Azure NoSQL database service for app development.
1,443 questions
Azure Event Grid
Azure Event Grid
An Azure event routing service designed for high availability, consistent performance, and dynamic scale.
314 questions
asked 2023-10-19T13:35:01.65+00:00
Given Mnisi
40
Reputation points
accepted 2023-10-19T19:45:53.7766667+00:00
Given Mnisi
40
Reputation points
1 answer
One of the answers was accepted by the question author.
User defined function doesn´t work because I use split method
I created user defined function in Azure stream analytics but this function doesn´t work because I use split method in my function Erorr code: Function 'splitandconverthex' resulted in an error: 'TypeError: Unable to get property 'split' of undefined…
asked 2023-10-11T15:48:50.1033333+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(172.8, 3%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPM%3C/text%3E%3C/svg%3E)
Prachar Marek
20
Reputation points
commented 2023-10-18T14:39:22.5933333+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,031
Reputation points
1 answer
One of the answers was accepted by the question author.
How to fix Microsoft Telcodata generator lab?
Hi, I just wanted to let you know that Microsoft's Telcogenerator.zip file is not work. Its not generating data once it used to when endpoint is been updated in the .exe config file. please look into the…
asked 2023-10-02T21:20:22.8466667+00:00
Ahad Sanji
25
Reputation points
accepted 2023-10-18T06:23:27.9733333+00:00
Ahad Sanji
25
Reputation points
0 answers
spark.readStream.text() text file from adls gen2 in databricks
file_path = "adl://<account-name>.dfs.core.windows.net/<container>/<path>/*.txt" streaming_df = spark.readStream \ .schema(schema) \ .text(file_path) query = streaming_df_transformed.writeStream \ …
asked 2023-10-05T15:48:37.58+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(147.20000000000002, 31%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESR%3C/text%3E%3C/svg%3E)
Sasidhar R. Kolli
20
Reputation points
commented 2023-10-17T18:56:28.1633333+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(86.4, 36%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBM%3C/text%3E%3C/svg%3E)
BhargavaGunnam-MSFT
26,136
Reputation points Microsoft Employee
1 answer
How do I pass all the JSON packets received in that particular tumbling window to the Javascript UDF function from the Azure Stream Analytics Query?
Below is my Azure Stream Analytics query. In this query, I have set the tumbling window for 10 seconds, and whatever data I will be receiving in these 10 seconds, I wanted to pass these complete packets in the "AggrFunction(IotMessage)" UDF…
asked 2023-10-13T07:09:56.4366667+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(124.80000000000001, 90%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDC%3C/text%3E%3C/svg%3E)
Deepak Chaurasiya
20
Reputation points
answered 2023-10-13T18:29:33.0366667+00:00
BhargavaGunnam-MSFT
26,136
Reputation points Microsoft Employee
0 answers
Azure Stream Analytics Test Query Does not work correctly with "WITH" clauses
Here is my query: WITH Stage1 AS ( SELECT records.ArrayValue.time as Recordedtime, records.ArrayValue.properties.flows as flows FROM [insights-logs-networksecuritygroupflowevent] as n CROSS APPLY GetArrayElements(n.records) AS…
asked 2023-10-02T06:32:13.2633333+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(230.39999999999998, 30%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EUJ%3C/text%3E%3C/svg%3E)
Ulla Jutila
0
Reputation points
commented 2023-10-09T17:59:34.4533333+00:00
BhargavaGunnam-MSFT
26,136
Reputation points Microsoft Employee
1 answer
Can Stream Analytics Update values in an existing table in Cosmos DB PostgreSQL?
Hi, I was wondering if I could update data in Cosmos DB for PostgreSQL table using Stream Analytics. I receive data through IOTHub and instead of adding rows of data I need to update values in different rows and columns. It seems that Stream Analytics…
asked 2023-09-25T00:36:43.08+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(25.6, 76%, 12%)' 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)
Ben Rad
0
Reputation points
commented 2023-10-03T08:49:05.4166667+00:00
ShaikMaheer-MSFT
37,896
Reputation points Microsoft Employee
1 answer
Aggregate within 7 days
Hi All, I have a stream analytics query that aggregates data within 7 days, but seems it is not getting data through in the output (cosmos db). Here is my sample query: SELECT a.Name, b.TotalAmt FROM table1 AS a LEFT OUTER JOIN ( SELECT Id, SUM(Amount)…
asked 2023-09-26T19:48:56.24+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(19.2, 79%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EG%3C/text%3E%3C/svg%3E)
ggonong
6
Reputation points
commented 2023-10-03T08:43:58.49+00:00
ShaikMaheer-MSFT
37,896
Reputation points Microsoft Employee
1 answer
"custom autoscale" in Stream Analytics Job is not enabled
When Custom auto scale is enabled in Stream Analytics?
asked 2023-09-30T21:01:23.0633333+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(310.4, 36%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EUS%3C/text%3E%3C/svg%3E)
Uma Sundar
5
Reputation points
answered 2023-10-02T23:06:30.8933333+00:00
QuantumCache
20,031
Reputation points
1 answer
One of the answers was accepted by the question author.
How to create azure data explorer output connection from stream analytics with az cli command
Hi Team, Could you please let us know how we can create output connection from stream analytics to azure data explorer with the help of AZ cli command or arm template ? I did not find the az cli command for azure data explorer output from stream…
asked 2023-02-14T13:43:04.17+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(268.8, 59%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
SaurabhShukla
101
Reputation points
commented 2023-09-28T17:12:21.54+00:00
Sander van de Velde
28,386
Reputation points MVP
1 answer
Are Azure Stream Analytics Job Resilient and zone redundant
Hi, I am looking at moving the current solution I have designed for a client to a production ready service. We are using a number of Azure resources from IaaS to PaaS. I am now looking at making this service production ready and need to understand the…
asked 2023-09-18T19:50:52.6+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(179.20000000000002, 76%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGM%3C/text%3E%3C/svg%3E)
GRAY Mike
161
Reputation points
commented 2023-09-28T08:37:49.3733333+00:00
PRADEEPCHEEKATLA-MSFT
77,086
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
Is there anything else to pay attention to when using GetArrayElements() function？
I create a UDF in Azure Stream Analysis,but there was an error when I called it, as follows: //ExtractDynamicFields(inputData) is the UDF,and it return the array type CROSS APPLY GetArrayElements(ExtractDynamicFields(event)) AS arrayElement //error…
asked 2023-09-21T08:08:18.81+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(172.8, 95%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKJ%3C/text%3E%3C/svg%3E)
kunming jian
40
Reputation points
accepted 2023-09-25T07:04:29.6166667+00:00
kunming jian
40
Reputation points
1 answer
One of the answers was accepted by the question author.
Como enviar a saída do Stream Analytics para o Power BI
Ola pessoal, Estou tentando enviar dados do Stream Analytics para o Power BI. Gostaria de saber se o usuário que estou usando no Azure tem que ser o mesmo que tem a conta no Power BI. Abs
asked 2023-09-21T19:29:23.92+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(262.40000000000003, 85%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECS%3C/text%3E%3C/svg%3E)
Cássio Luis Ferreira
20
Reputation points
accepted 2023-09-21T21:49:06.1966667+00:00
Cássio Luis Ferreira
20
Reputation points
1 answer
One of the answers was accepted by the question author.
Stop , Delete actions disabled in portal for running Stream Analytics
After start of Stream Analytics job I've created , there is no possibility to Stop it. And i lost access to all information related to the job. Based on log job started succesfully (and it is doing what is supposed to do). In IAM I'm reflected as owner…
asked 2023-09-19T14:19:36.3066667+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(3.2, 24%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELN%3C/text%3E%3C/svg%3E)
Lukasz Nalichowski
20
Reputation points
accepted 2023-09-20T15:35:45.8733333+00:00
Lukasz Nalichowski
20
Reputation points
1 answer
One of the answers was accepted by the question author.
How can I output data to output sources with the same alias?
My stream analysis job generates different types of data when processing input source data. How can I sequentially output these data to output sources with the same alias? Or what other methods are there？If I cannot output to an output source with the…
asked 2023-09-20T09:34:51.8+00:00
kunming jian
40
Reputation points
accepted 2023-09-20T11:17:02.2566667+00:00
kunming jian
40
Reputation points