Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Can one have multiple queries in streaming analytics job?

As the title says, can you have more than one query in an Azure Streaming Analytics job? If so, how should that be structured?

like image 962
acecabana Avatar asked Mar 29 '16 14:03

acecabana


People also ask

Can we put data into multiple output files through Stream Analytics job?

You can join data from multiple inputs to combine streaming events, and you can do lookups against static reference data to enrich the event values. You can also write data to multiple outputs.

How many streaming units SUs can you apply to an azure stream analytics job if the input and output both contain 10 partitions?

Every 6 SUs corresponding to one streaming node for your job.

How does Azure Stream Analytics work?

How Does Azure Stream Analytics Work? An Azure Stream Analytics job consists of an input, query, and an output. It ingests data from Azure Event Hubs, Azure IoT Hub, or Azure Blob Storage. The query is based on SQL query language and can be used to easily filter, sort, aggregate, and join streaming data.


1 Answers

yes, you can have multiple queries in stream analytics job. You would do something like below

select * into type1Output from inputSource where type = 1
select * into type2Output from inputSource where type = 2

The job has two outputs defined, called type1Output and type2Output. Each query writes to a different output.

like image 73
Vignesh Chandramohan Avatar answered Oct 21 '22 10:10

Vignesh Chandramohan