Questions tagged [azure-stream-analytics]
Related to Microsoft Azure Cloud Analytics system
azure-stream-analytics
933
questions
0
votes
1
answer
15
views
Azure Stream Analytics get counts only if count has changed between windows
I'm trying to create a query in Azure Stream Analytics that each hour will give me number of events (grouped by some columns) in last 8 hours.
I'm using HoppingWindow(hour, 8, 1) in my GROUP BY clause ...
0
votes
0
answers
38
views
How do I make Stream Analytics always send one event at a time with LineSeparated?
I'm facing a problem with Azure Stream Analytics and I need help...
Contextualizing...
I have a stream where I receive events from an Event Hub topic in Stream Analytics. When these events arrive in ...
0
votes
1
answer
46
views
Merge multiple rows into a single row in Azure Stream Analytics Job
In Azure Stream Analytics Job, I want to group multiple rows in to a single row. For now I was using Group By in query but some columns vlaue are setting to null. I have also verified the json input ...
0
votes
1
answer
31
views
Json parsing- array value - Azure stream Analytics
I am trying to explode the array value. But I am getting error `'Apply' can only be used with functions 'getarrayelements, getrecordproperties'.
select a.[id],row1.arrayvalue from input a
CROSS APPLY
...
0
votes
1
answer
48
views
Azure Stream Analytics Window Agg
how to solve the problem in azure stream analytics using windowing functions
col1
col2
status
flag
Q1
P1
started
1
Q1
P1
connected
1
Q1
P1
ended
0
Q1
P1
completed
0
Q1
P2
started
1
Q1
P2
...
0
votes
1
answer
48
views
Json is not parsing - syntax error- stream analytics
I am trying to parse Json data using azure stream analytics. I am getting the below error.
Syntax errors: Incorrect syntax near duration. Location: line '4', column '5'.
SELECT
duration.value,
...
0
votes
1
answer
40
views
Azure Stream Analytcs Reading data from Event Hub
I have the below structure JSON data coming from event hub, and I am trying to process the same using Azure Stream Analytics.
I have tried some of the methods to extract the array elements from that ...
0
votes
1
answer
29
views
Azure streaming from azure SQL datatbase failing
The issue i am having is that i am working on streaming data from Azure SQL Database, & to do that i created a reference data input from azure sql db, blob input stream & output that pushes to ...
0
votes
1
answer
33
views
Adding Azure Machine Learning Service function on Azure Stream Analytics Jobs
I am trying to add Azure Machine Learning Service function on a streaming job using a pretrained hugging-face sentiment analysis model (cardiffnlp-twitter-roberta-base-sentiment)
While adding the ...
0
votes
0
answers
49
views
Azure automation failed when starting stream analytics
I have set up an automation app to stop and start a stream analytics job, following a guide from this doc
I have tried the code, yet it is struggling to pull a value from the stopped log in azure ...
0
votes
1
answer
70
views
Azure Steam Analytics Query
I want to store the below JSON data to the Azure table. Here the input and the output for Azure Stream Analytics are Azure IoT Hub and table respectively.
[
{
"device1": [
{
...
0
votes
1
answer
67
views
System Properties of D2C IoT Hub messages not appearing within Route to Non Default Event Hub
I'm facing an issue with Azure IoT Hub when routing device-to-cloud (D2C) messages to a custom Event Hub, specifically related to system properties within the JSON payload. Normally, when messages are ...
0
votes
1
answer
56
views
Stream Analytics - Output Device Messages Only Upon Change
I'm currently setting up a job that forwards IoT Device based Event Hub data (JSON payloads) for multiple devices to a database.
The job forwards to an SQL table right now which is great (easy part), ...
1
vote
0
answers
99
views
Stream Analytics Job output to immutable storage account fails
I have configured a Stream Analytics Job to write output to a Storage Blob Container with an immutability policy. According to the provided documentation (link), with an immutable storage container, a ...
0
votes
0
answers
22
views
Parse JSON property name beginning with a numeric character in Azure Stream Analytics
How can I parse the JSON property '1CustomSensor' in an Azure Stream Analytics Query?
{
"DeviceId" : "12345",
"Location" :
{
"Lat": 47,
"Long":...