Questions tagged [stream-analytics]
87 questions
0
votes
1 answer
Deploy C# Storm topologies to a local/on premise Storm cluster
I need to do some data analytics on data acquired from IOT sensors (CEP, outliers detection, etc.)
I searched over the internet to find which tool I can use according to our constraints:
All developers in my team are C# developers
The solution…
Dovic
- 1
- 1
0
votes
2 answers
Azure Stream Analytics Query for Power BI
I'm having an issue extracting data out of events coming from Azure IOT Hub to Azure Stream Analytics (ASA) to Power BI.
Here is an example of the feed coming into Azure IOT Hub:
"data":…
0
votes
1 answer
Stream Analytics job reference data join creating duplicates
I am using Stream Analytics to join streaming data (via IoT Hub) and reference data (via blob storage). The reference data blob file is generated every minute with latest data and is in a format "filename-{date} {time}.csv". The reference blob file…
SHB
- 87
- 2
- 8
0
votes
1 answer
Preparing archive data for Stream Analytics Import
Before I had time to get an ingestion strategy & process setup, I started collecting data that will eventually go through a Stream Analytics job. Now I'm sitting on an Azure blob storage container with over 500,000 blobs in it (no folder…
Andrew Connell
- 4,939
- 5
- 30
- 42
0
votes
1 answer
Promoting known properties from record to top level result in Stream Analytics Query
I have a series of dynamic data being processed by a Stream Analytics job. There are a few uniform properties that I can explicitly query for, but the bulk of the payload is of an unknown type at query time. My goal is to take this unknown data (the…
Andrew Connell
- 4,939
- 5
- 30
- 42
0
votes
1 answer
How to count the number of events in a single window with Stream analytics?
I am trying to create a query that uses StreamAnalytics's SlidginWindow function and outputs more than five events in 5 minutes
Although it is possible to count if there is a record with the following code, this case is 1 record 5 events so it can…
Re-no
- 1
0
votes
1 answer
Wrapping JSON into output Stream Analytics query
I am using Stream Analytics query to filter my inputted Complex Json object.
Input:
{
"id" : "001",
"firstArray":[
{
"tid" : 9,
"secondArray":[
{
"key1" : "value1",
"key2" : "value2"
…
Sam
- 9
- 3
0
votes
1 answer
Create JSON object with Stream Analytics query
I'm trying to format an incoming JSON object as JSON object into output
input:
{
"id" : "001",
"firstArray":[
{
"tid" : 9,
"secondArray":[
{
"keep1" : "value1",
"keep2" : "value2",
…
Sam
- 9
- 3
0
votes
1 answer
Azure Stream Analytics Windowing
I'm having some trouble with Stream Analytics Windowing. The input to my Stream Analytics Job is an event stream that contains temperature readings from sensors/entities which belong to a signal. Every signal has about 600 entities. A sample event…
majortom
- 1
- 2
0
votes
1 answer
Stream Analytics - How would I convert timestamp in string to Date/Time?
So I have timestamp which I need to convert into time. So I have tried this
Convert From Bigint to datetime value
But it is not working in Azure Function App :/
Basically I have this code
SELECT
dateadd(s, convert(bigint, XEvent.[Timestamp]) /…
Vess
- 249
- 1
- 3
- 10
0
votes
1 answer
How can I use ML function in Azure Stream Analytics?
I try to use a trained model from Microsoft Azure Machine Learning Studio in Azure Stream Analytics.
Before I start work with my IoT-Stream sensor data, I try this sample:…
cSteusloff
- 2,487
- 7
- 30
- 51
0
votes
2 answers
How to render JSON using Stream Analytics Query
I have Inputs in the form of JSON stored in Blob Storage
I have Output in the form of SQL Azure table.
My wrote query and successfully moving value of specific property in JSON to corresponding Column of SQL Azure table.
Now for one column I want to…
Abhi
- 5,501
- 17
- 78
- 133