Related to Microsoft Azure Cloud Analytics system
Find more information about Azure Stream Analytics:
Questions tagged [azure-stream-analytics]
919 questions
2
votes
0 answers
Azure Stream Analytics: ML Service function call in cloud job results in no output events
I've got a problem with an Azure Stream Analytics (ASA) job that should call an Azure ML Service function to score the provided input data.
The query was developed und tested in Visual Studio (VS) 2019 with the "Azure Data Lake and Stream Analytics…
Phil Leh
- 758
- 5
- 14
2
votes
2 answers
Secrets in Azure Stream Analytics
In our Stream Analytics Job we have some constant values that are required for further computations. Those are considered "secret" by our customer, so it would be good to not have them set directly in the Query or the User Defined Function we're…
Thomas
- 4,030
- 4
- 40
- 79
2
votes
1 answer
Azure Stream Analytics: Regex in Reference Data
I have an Azure Stream Analytics job that uses an EventHub and a Reference data in Blob storage as 2 inputs. The reference data is CSV that looks something like this:
REGEX_PATTERN,FRIENDLY_NAME
115[1-2]{1}9,Name 1
115[3-9]{1}9,Name 2
I then need…
user_name
- 119
- 1
- 8
2
votes
1 answer
Azure Stream Analytics input blob storage dynamic path pattern
I have an Azure Stream Analytics resource with a Blob Storage as input (so not output I can read enough docs about that). The problem is that my path pattern is dynamic. We make directories in this Blob Storage to identify batches like…
Danny van der Kraan
- 5,344
- 6
- 31
- 41
2
votes
2 answers
Stream analytics - How to handle json in reference input
I have an Azure Stream Analytics (ASA) job which processes device telemetry data from event hub. The stream should be joined with reference data from a sql table, to enhance each message with additional device meta data. The merged entry should be…
filip
- 1,444
- 1
- 20
- 40
2
votes
1 answer
Azure Stream Analytics reference input cannot read from Storage blob
We are trying to create a Storage reference input for Azure Stream Analytics job and all the configuration and the test goes well, however when we try to use it in a Query, we get the following messages in the portal UI: "While sampling data, no…
toddysm
- 598
- 3
- 5
- 15
2
votes
1 answer
azure stream analytics custom json output
I need to convert simple json telemetry packet to custom json output. Can you please help me to achieve this.
INPUT to stream analytics
{"Id":80,"deviceId":"10004","temperature":21.94489404790873,"humidity":63.377043919318496}
Output of stream…
mbr
- 913
- 1
- 11
- 22
2
votes
1 answer
Join in Stream Analytics with an element in an Array
I am trying to do a join in stream analytics with a reference data.
Below is the input from stream data.
[{
"id":"111111101",
"basetime":0,
"xyz":
[
{
…
Antony
- 970
- 3
- 20
- 46
2
votes
1 answer
Stream Analytics query hits size limit
I'm new to Azure Stream Analytics. I have an Event hub as input source and now I'm trying to execute a simple query on this stream. An example query is like this:
SELECT
count(*)
INTO [output1]
FROM
[input1] TIMESTAMP BY Time
GROUP BY…
GANdalf85
- 129
- 1
- 7
2
votes
2 answers
How to update data azure SQL database using stream analytics?
How to update or delete data in azure sql DB using azure stream analytics
saran k
- 307
- 2
- 14
2
votes
1 answer
How to use CosmosDb with partition key as a Stream Analytics output?
I'm setting up CosmosDb with a partition key as a Stream Analytics Job output and the connection test fails with the following error:
Error connecting to Cosmos DB Database: Invalid or no matching collections >found with collection pattern…
bnm91
- 33
- 1
- 4
2
votes
1 answer
Azure Stream Analytics output to Azure Cosmos DB
Stream Analytics job ( iot hub to CosmosDB output) "Start" command is failing with the following error.
[12:49:30 PM] Source 'cosmosiot' had 1 occurrences of kind
'OutputDataConversionError.RequiredColumnMissing' between processing
times…
Chandra
- 515
- 6
- 19
2
votes
1 answer
Azure Stream Analytics 'TimeStamp By' in query doesn't works on job but works fine on test
I'm working on a IoT project. I've a Raspberry pi which send data to an IoTHub on Azure. That Hub forwards that data to an Azure Stream Analytics Job. In my query I try to aggregate(here an average) all the data in a TumblingWindow of 1 minute but…
ulysse
- 23
- 5
2
votes
1 answer
How to check null values in JSON property in stream analytics?
I am Passing the following Json input from Eventhub to Stream Analytics.
{"meter_totalcycleenergy":null,"Test2": 20}, {"meter_totalcycleenergy":40,"Test2":20}
But the job is failing stating the error.
Encountered error trying to write 1 event(s):…
Kiran B Chitari
- 111
- 10
2
votes
1 answer
How to get Azure Stream Analytics output into an Azure SQL DB
How to make Stream Analytics output shown in Azure SQL database, do I have to create a new table? If so, what data name and type should I input, refering to Raspberry Pi Azure IoT Web…
Chen
- 171
- 3
- 14