Apache Drill, Azure Blobs and Azure Stream Analytics

With Apache Drill querying Azure Stream Analytics job results in real time is really easy

Installing Apache Drill (on Windows 10)

set "HADOOP_HOME="
sqlline -u "jdbc:drill:zk=local"

Installing Azure Blob Store JARs

Configuring the Storage Plugin

<?xml version="1.0" encoding="UTF-8" ?>
<configuration>
<property>
<name>fs.azure.account.key.ACCOUNT_NAME.blob.core.windows.net</name>
<value>ACCOUNT_KEY</value>
</property>
</configuration>

Querying Azure Stream analytics results

The alternative: Dockerize Everything

--

--

Notes on creating streaming at scale solution in the Azure cloud

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Davide Mauri

Data Geek, Storyteller, Developer at heart, now infiltrated in Azure SQL product group to make sure developers voice is heard loud and clear. Heavy Metal fan.