Drill 1.10.0 Installation & Configuration

Apache Drill is an open-source software framework that supports data-intensive distributed applications for interactive analysis of large-scale datasets. Apache Drill is first schema-free SQL engine. Unlike Hive, it does not use MR job internally and compared to most distributed query engines, it does not depend on Hadoop.

Prerequisites

Java 8
ZooKeeper quorum

Download and Installing Drill

Download Drill 1.10.0 using below command on /usr/local directory.

$ cd /usr/local $ sudo wget http://www-eu.apache.org/dist/drill/drill-1.10.0/apache-drill-1.10.0.tar.gz

Unpack the compressed tar file by using this command

$ sudo tar -xvf apache-drill-1.10.0.tar.gz

Rename apache-drill-1.10.0 directory to drill in /usr/local directory by using give command

$ sudo mv apache-drill-1.10.0 drill

Setting up Drill Environment Variables

First we need to set environment variable for Drill. Edit ~/.bashrc file.

$ sudo nano ~/.bashrc

Append following values at end of file and save the file.

export DRILL_HOME=/usr/local/drill export PATH=$DRILL_HOME/bin:$PATH

Change the ownership and permissions of the directory /usr/local/drill

$ sudo chown -R hdfs:hdfs /usr/local/drill $ sudo chmod -R 755 /usr/local/drill

Reload the configuration file ~/.bashrc with the following command.

$ source ~/.bashrc

Start Drill services

To stat Drill service used following command

$ drill-embedded

Java HotSpot(TM) 64-Bit Server VM warning: ignoring option MaxPermSize=512M; support was removed in 8.0 Jul 20, 2017 7:19:59 PM org.glassfish.jersey.server.ApplicationHandler initialize INFO: Initiating Jersey application, version Jersey: 2.8 2014-04-29 01:25:26... apache drill 1.10.0 "say hello to my little drill"

Drill Web Interfaces

Access your Drill Web Interfaces on port 8047 in your favorite web browser.

http://localhost:8047

Showing below web Interface

Read More