Questions tagged [stream-analytics]
87 questions
0
votes
1 answer
Azure stream analytics custom output data with CASE statement
I have problem to counting user of each zone, each user will send locale of them to server. Can someone help me to achieve this, thank you.
Output stream analytics should be this:
{
"sessionId": "sessionId1", -->group by sessionId
"data": {
…
vthanhduc
- 3
- 2
0
votes
0 answers
Azure Stream Analytics - Count True Values
I am trying to do a count of results in Azure Stream Analytics that are a certain value using the following query:
WITH IoTData AS
( SELECT *,
CAST(iothub.time AS datetime) AS time,
TRY_CAST(iothub.value AS float) AS value,
…
sandrews
- 1
- 2
0
votes
1 answer
Find number of queries that appear at least 3 minutes in 5 minutes tumbling window in Azure Stream Analytics
I need to find clients that appear at least 3 minutes in 5 minutes Tumbling window in Azure Stream Analytics.
Below code can find the number of people appear in 5 minutes window.
SELECT
apMac,
COUNT(Distinct([clientMac])) AS…
shnpsm
- 11
- 4
0
votes
1 answer
Azure Stream Analytics - no input events when using refrence data
My Azure Stream Analytics Job does not detect any input events if I use reference data in the query. When I'm using only streaming data it works well.
Here is my query:
SELECT v.localization as Station, v.lonn as Station_Longitude, v.latt as…
jkrys
- 13
- 4
0
votes
1 answer
Extract certain values from Arrays in Azure Stream Analytics and then adding other values manually
I have set up some sensors were I recieve the data (JSON) trough Event Hub to a Stream Analytics job and down to Data Lake Gen2. I Just need some of the values from the data and want to add some values e.g Floor, Room since these data is not…
skh
- 27
- 4
0
votes
1 answer
azure Stream analytics isfirst and last query
I have the payload something like below. I need to get the first distinct batch values for every 1 minute period. Please let me know how to achieve this in stream analytics using isfirst and lag or last
Output…
mbr
- 913
- 1
- 11
- 22
0
votes
1 answer
azure stream analytics implementation or the best approach
I am new to Steam analytics and I need help here to achieve a specific task.
I have telemetry data coming from iot hub in this format.
Basically i will be getting machines telemetry data and the stage of the operations on that machine streamed to…
mbr
- 913
- 1
- 11
- 22
0
votes
1 answer
Restriction of sending events based on time In Stream Analytics Azure
In my Azure Stream Analytics Job, Want to restrict events sending to service bus queue after certain time of the day.
SA Query :
Select
*
INTO
servicebusqueue
FROM
eventhub
Where name = 'abc'
*AND Time < 1 PM*
How to write query for…
learner
- 223
- 3
- 19
0
votes
1 answer
Is there any way to check if my Stream Analytics input is already in a table?
I have an input from a iothub to a stream analytics(SA). This input contains data detected by a Bluetooth device and I store them on a data base (an output of the SA), in a table called InputMessages. The problem is that I have another table…
ah4b
- 11
- 4
0
votes
1 answer
Runtime errors for Azure stream Analytics Job
I tried to modify an existing azure stream analytics job by adding one more temporary result set.
But when I run the SA job, it is throwing runtime error and watermark delay is getting increased.
Below is the existing SAQL in the Stream Analytics…
Antony
- 970
- 3
- 20
- 46
0
votes
2 answers
Error code: BadArgument Error message while sampling data from Azure Stream Analytics Job
I tried to take sample data from a running Azure Stream Analytics Job. The job is running successfully and the output is writing into cosmos DB successfully.
But when I tried to take sample data from the streaming input, Sampling is failed and I am…
Antony
- 970
- 3
- 20
- 46
0
votes
1 answer
Compare length batches of data with each other in Siddhi
I've defined the input stream below. The Datetime string is like 2010-09-01 06:59:00.000, the result is a double like 157,382 and the UnixDateTime is in type long like 1283324340111.
define stream HStream(ID int, DateTime String, Result double,…
user7432713
- 197
- 3
- 17
0
votes
1 answer
Compare batches of average values with each other in WSO2 Stream Processor
I've written some code in Siddhi that logs/prints the average of a batch of the last 100 events. So the average for event 0-100, 101-200, etc. I now want to compare these averages with each other to find some kind of trend. In first place I just…
user7432713
- 197
- 3
- 17
0
votes
1 answer
Multiple LEFT JOINS are not working as expected in Azure Stream Analytics
Multiple LEFT JOINS are not working as expected in Azure Stream Analytics.
I am using LEFT joins in Azure Stream Analytics and getting values for the first Two JOINS and null value for the rest of the LEFT JOIN
The below is the Json input i have…
Antony
- 970
- 3
- 20
- 46
0
votes
0 answers
To Find Distinct values after doing a UNION operation in Azure Stream Analytics
I am running a query in Stream analytics with a UNION function.
I would like to get the distinct values for the query results. Since the UNION is allowing duplicates in Azure Stream Analytics I am getting result with duplicate values. I have tried…
Antony
- 970
- 3
- 20
- 46