Running Apache Drill

Prerequisites

• Linux, Windows or OSX
• Oracle/OpenJDK 8 (JDK, not JRE)

Additional requirements when running in clustered mode:

• Hadoop 2.3+ distribution of Hadoop (such as Apache or MapR)
• Zookeeper is required for a clustered installation

Installing the Tarball

1. mkdir /opt/drill
2. tar xvzf [tarball] --strip=1 -C /opt/drill

Running in embedded mode

1. cd /opt/drill
2. bin/sqlline -u jdbc:drill:zk=local
3. Run a query (below).

Running in clustered mode

1. Edit drill-override.conf to provide zookeeper location
2. Start the drillbit using bin/drillbit.sh start
3. Repeat on other nodes
4. Connect with sqlline by using bin/sqlline -u “jdbc:drill:zk=[zk_host:port]”
5. Run a query (below).

Run a query

Drill comes preinstalled with a number of example data files including a small copy of the TPCH data in self describing Parquet files as well as the foodmart database in JSON. You can query these files using the cp schema. For example:

USE cp;

SELECT 
  employee_id, 
  first_name
FROM `employee.json`; 

More information

For more information including how to run a Apache Drill cluster, visit the Apache Drill Documentation