Looking to do real time metric calculations on event streams, what is a good choice in Azure? Stream Analytics or Storm? I am comfortable with either SQL or Java, so wondering what are the other differences.
Azure Stream Analytics is a fully managed, real-time analytics service designed to help you analyze and process fast moving streams of data that can be used to get insights, build reports or trigger alerts and actions.
Azure Stream Analytics uses a SQL query language that has been augmented with powerful temporal constraints to analyze data in motion.
Creation, test and preparation of the job in Azure Stream Analytics portal is free. Deployment of the job and monitoring of your job will require the use of messages which will count towards your IoT Hub allowance.
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.
It depends on your needs and requirements. I'll try to lay out the strengths and benefits of both. In terms of setup, Stream Analytics has Storm beat. Stream Analytics is great if you need to ask a lot of different questions often. Stream Analytics can also only handle CSV or JSON type data. Stream Analytics is also at the mercy of only sending outputs to Azure Blob, Azure Tables, Azure SQL, PowerBI; any other output will require Storm. Stream Analytics lacks the data transformation capabilities of Storm.
Storm:
Stream Analytisc
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With