Stack Overflow
Stack Overflow

Questions tagged [azure-stream-analytics]

Related to Microsoft Azure Cloud Analytics system

Find more information about Azure Stream Analytics:

919 questions
4
votes
1 answer

Custom timestamp is not taken into account in blob path for Stream analytics

Given a query that looks like this: SELECT EventDate, system.Timestamp as test INTO [azuretableoutput] FROM [csvdata] TIMESTAMP BY EventDate According to documentation, EventDate should now be used as timestamp. However, when…
ruffen
  • 1,695
  • 2
  • 25
  • 51
4
votes
4 answers

Live location data from ASA to Power BI Map

I've got a ASA output which sends the GPS coordinates of some devices devices to a Power BI Live datastream. Data from ASA to Power BI looks something like this: Device Lat Lon Time 1 1,12345 2,34567 19-1-2018…
Rody
  • 2,675
  • 1
  • 22
  • 40
4
votes
1 answer

Select the first element in a JSON array in Microsoft stream analytics query

So I got a bit of a problem. I retrieve some weatherdata from an external API. This is returned as JSON and send to an Azure IoT hub. Stream analytics processes the json into a proper format, but I got a problem here. The element: Current_Condition,…
Arastelion
  • 313
  • 5
  • 13
4
votes
1 answer

T-SQL Azure Stream Analytics Rounding to Minute

I have the following SELECT clause in my Azure Stream Analytics Query: SELECT DateAdd(mi, DateDiff(mi, 0, DateAdd(s, 30, Max(timecreated))), 0) as 'timestamp' Which is giving the following error: Second parameter of 'DateDiff' in expression…
ReignOfComputer
  • 747
  • 2
  • 10
  • 30
3
votes
1 answer

Azure Event Hub diagnostic set up for User Errors

I am running a set up, where Stream Analytics job is reading from Azure Event Hub. Event Hub is contained within a namespace and there is consumer group created for SA specifically. Recently I noticed User Error on Event Hub metrics. Event Hub…
Majus Misiak
  • 643
  • 7
  • 14
3
votes
3 answers

Data flow: Azure Event Hubs to Cosmos db VS Cosmos db to Azure Event Hub - Better option?

I want to monitor some events coming from my application. One option is to send data to Azure Event Hub and use stream analytics to do some post-processing and enter the data into cosmos db. Another option is to store to cosmos db from application…
Pranav Raj
  • 781
  • 1
  • 8
  • 19
3
votes
2 answers

How to read IoT Hub message 'application properties' in Stream Analytics?

I have enriched the IoT Hub message based on Microsoft documentation and routing it to the built-in endpoint, and then having Stream Analytics access the messages by providing IoT Hub as the input to it. IoT Hub message enrichment adds the…
Govind
  • 31
  • 2
3
votes
1 answer

Azure Stream Analytics Session window abnormal behavior

In my Azure Stream Analytics Job, I want to create a window for each device (When data received for device). I'm using session window to maintain a separate window for each device. I want temperature threshold breach alert in every 5 minutes but…
Pankaj Rawat
  • 4,037
  • 6
  • 41
  • 73
3
votes
3 answers

Can I have multiple queries in the same output in Azure Stream Analytics Job?

Can I have multiple queries in the same output in Azure Stream Analytics Job? For example SELECT property1, property2 INTO Output1 WHERE Property3 ='Answer' SELECT property4, property5 INTO Output1 WHERE Property3 ='Question'
Georgia Kalyva
  • 737
  • 2
  • 9
  • 23
3
votes
0 answers

Azure IoT Hub receiving messages late

In our IoT Solution that utilizes Azure IoT Hub on server side and Azure IoT Client SDK on Device side, we are seeing intermittent delay in time between device sent a status message over MQTT and message was received by IoT Hub. In some cases, we…
SBirthare
  • 5,117
  • 4
  • 34
  • 59
3
votes
2 answers

Azure Stream Analytics - Query along the stream

I am using Azure Stream Analytics. I have data coming into event hubs. The data coming in looks as below: [ { "id": "a2b8bcd8-ff79-4bb7-a86f-615556104c1f", "mechanism": "geo", "datetimereporting": "2017-07-23…
ajones
  • 31
  • 1
3
votes
3 answers

CSV reference data in Azure Stream Analytics

I have a stream analytics application where events are JSON encoded and look like this {customerID: 45, state:"S2" , timestamp:"2017-06-06 14:19:21.77"} {customerID: 74, state:"S2" , timestamp:"2017-06-06 14:19:26.61"} {customerID: 79, state:"S2" ,…
nihil0
  • 359
  • 2
  • 10
3
votes
3 answers

Defining Azure Stream Analytics iot-hub input source through Powershell

I'm trying to write a powershell script that creates a new streamAnalytics job in my azure portal account, with input source as iot-hub and output source as blob storage account. To do so, I'm using AzureRM command new-streamAnalyticsJob, and json…
N.avraham
  • 333
  • 2
  • 15
3
votes
1 answer

Error when creating a blob storage output for Stream Analytics using Powershell

I'm trying to create a Stream Analytics blob storage output using powershell. This is the command I'm using: New-AzureRMStreamAnalyticsOutput -ResourceGroupName $ResourceGroupName -JobName $JobName –File soutput.json" -Force and the output.json…
Reginbald
  • 325
  • 4
  • 11
3
votes
2 answers

Stream analytics resume behavior

I have an EventHub stream as input and a Service Bus Queue as output. My query uses TUMBLINGWINDOW to aggregate events to output to the queue from the stream. If I have to pause the Stream Analytics and resume it later from the point it stopped,…
Stefano d'Antonio
  • 5,874
  • 3
  • 32
  • 45
1
2
3
…
61 62