Connect Drill to an Azure SQL Database

NOTE This post is part of a series on a deployment of Apache Drill on the Azure cloud. The intent of Apache Drill is to make it easy for you to query across a wide-range of relational and NoSQL data stores.  If you are running Drill in Azure, you are likely leveraging Azure SQL Database…

0

Configuration of Azure Blob Storage (aka WASB) as a Drill Data Source

NOTE This post is part of a series on a deployment of Apache Drill on the Azure cloud. Azure Storage Blobs – aka WASB after the WASB in Hadoop for accessing it – provide a low-cost means to store files in Azure. As Drill is commonly used to query data residing in file systems, it would…

0

Configuration of the Drill Cluster

NOTE This post is part of a series on a deployment of Apache Drill on the Azure cloud. With our Azure resources deployed and the ZooKeeper ensemble up and running, we can now proceed with the installation and configuration of Drill.  I’ve deployed four VMs on which I intend to run the Drill software.  The…

0

Configuration of the ZooKeeper Ensemble

NOTE This post is part of a series on a deployment of Apache Drill on the Azure cloud. With the VMs and other components of the Drill topology deployed into Azure, I can now start configuring the various services.  I need to start with ZooKeeper as the Drill services depend upon it. The major steps…

0

The Deployment Mechanics for the Drill Infrastructure

NOTE This post is part of a series on a deployment of Apache Drill on the Azure cloud. In my last post, I described the topology of a Drill deployment in Azure.  In this post, I will present a PowerShell script for the deployment of that topology. If you are more comfortable with BASH scripting, you…

0

An Overview of an Apache Drill Topology in Azure

NOTE This post is part of a series on a deployment of Apache Drill on the Azure cloud. Apache Drill supports both embedded, i.e. single-server, and distributed deployments.  To meet my customer’s needs, I need both the scale and reliability of a multi-server solution so that I have elected to deliver a distributed deployment. While…

0

Deploying Apache Drill on Azure

I have a customer interested in leveraging Apache Drill for interactive queries on data resident in the Azure cloud. In developing a solution for this customer, I have found the Apache Drill documentation to be a bit sparse so that it is my hope that what I post in this series may be of assistance…

1