Questions tagged [stream-analytics]
87 questions
0
votes
1 answer
Is there a way to calculate the duration in stream analytics in case a input parameter has changed?
I am trying to calculate the duration of a signal (DI_1) from an datalogger which is connected to azure IoT Hub and stream analytics.
The input data looks like:
DateTime Digital Input
22.04.2019 14:17:00 0
22.04.2019 14:16:00 …
Maxcel
- 21
- 4
0
votes
2 answers
Stream analytics getting average for 1 year from history
I have Stream Analytics job with
INPUTS:
1) "InputStreamCSV" - linked to Event hub and recievies data . InputStreamHistory
2) "InputStreamHistory" - Input stream linked BlobStorage. InputStreamCSV
OUTPUTS:
1) "AlertOUT" - linked to table storage…
Kurt
- 3
- 1
0
votes
2 answers
Stream Analytics - How to do a FULL OUTER JOIN with reference data?
I'm using Stream Analytics' T-SQL to do a full outer join of a stream input and a reference data input.
I've tried the following query but I keep getting an error saying "When joining stream and reference data, reference data must be on the right…
CompilationError
- 15
- 4
0
votes
0 answers
How to store UDF return value for incoming events using Stream Analytics?
I need to translate the C# code below into something that can be used by Azure Stream Analytics.
I've got a C# application that is similar to the following:
var inputEvents = new List();
foreach (var file in files){
(List events,…
CompilationError
- 15
- 4
0
votes
1 answer
Stream analytics geospatial function usage
I want to use Stream Analytics geospatial functions by using the latitude/longitude data (sent via Azure IoTHub) and a target latitude/longitude or polygon data (from reference input).
I know we can join stream and reference inputs in a query but…
dansc
- 219
- 3
- 12
0
votes
1 answer
Azure stream analytics anomaly function returning Exception
We have an IOT application. Application has to detect any sudden changes(anomaly) in the device battery voltage. We were planing on using anomaly function built into stream analytics in azure for accomplishing this task.
When I'm running anomaly…
Vishnu Kv
- 25
- 5
0
votes
2 answers
Azure Stream Analytics Tool for Visual Studio in 2019 preview
I am just creating an Azure Stream Analytics using Azure Stream Analytics Tool for Visual Studio in 2019 preview version, but it is saying that the version of Visual Studio is not supported. I am sure that I have installed the required workloads and…
Sibeesh Venu
- 18,755
- 12
- 103
- 140
0
votes
1 answer
Selecting partial data from stream analytics input
I have a stream analytics job that recieves input from an IOT hub and writes data to an azure SQL database. My current query is as follows
Select [Column1,Column2...] INTO [Output] from [Input]
Is it possible to select only specific number of rows?…
0
votes
1 answer
Power BI is not getting included in Stream Analytics template json
Have created a Stream Analytics project in visual studio, with input as event hub and output as Power BI. On building the project, the resulting template json does not include the power bi output details.
Below is the details of output.json. I see…
Rima
- 545
- 6
- 12
0
votes
1 answer
Stream Analytics too slow (time slippage between two streams)?
Here's my stream analytics topology
EventHubSource => Job A (HoppingWindow every second) => EventHubA
EventHubSource => Job B (HoppingWindow every second) => EventHubB
Each job has a different consumer group in EventHubSource.
Each job is…
Yanis26
- 247
- 2
- 13
0
votes
2 answers
stream analytics - converting incoming JSON to PowerBI streaming dataset
I have a sensor which is reporting data into the IoTHub in the following format (via a Modbus server):
15/05/2018 14:56:56> Device: [dev],…
Dave Banthorpe
- 51
- 5
0
votes
1 answer
Azure Stream Analytics: Calculate Slope from a Sliding Window
Data structure: {sensorId: 1, temp: 20, timestamp: 1525119377241}
Window Query:
SELECT
System.Timestamp as WindowEnd,
sensorId,
AVG(temp) AS avgTemp,
FROM
SensorStream TIMESTAMP BY timestamp
GROUP BY
sensorId,
…
Yanis26
- 247
- 2
- 13
0
votes
1 answer
Extracting Array inside a Property in Azure Stream Analytics
I have had no luck so far extracting certain values in a wide format out of a JSON string via a stream analytics job.
The JSON has the following…
Markus Schmitz
- 97
- 3
- 13
0
votes
1 answer
Using storm IEventLogger for logging events into DB
Coul'd you please ask me, who used storm IEventLogger interface for logging event values. I can't understand, how it use in Some custom java application. It will use some thread or with thread of applcation? How we need to get/set storm config and…
user5730669
- 21
- 2
0
votes
1 answer
Can Azure Stream Analytics read Bond serialized events?
I am trying to to some POC using Azure Stream Analytics. I want to read from Azure Event Hub and store to Azure Blob Storage. I work with this guide. The problem is that when I define my stream input (as my existing event hub) I see that stream…
Zorik
- 207
- 1
- 3
- 9