Apache Drill on MapR

Document created by maprcommunity Employee on Nov 17, 2017Last modified by maprcommunity Employee on Apr 30, 2018
Version 26Show Document
  • View in full screen mode


Apache Drill is an open source, MPP query engine that delivers interactive SQL analytics at massive scale. With in-place analytics capabilities, Drill on MapR Converged Data Platform enables self-service data exploration on historical data stored in a variety of file formats (Parquet, JSON, CSV, TSV) and operational data stored in MapR-DB. Drill is ANSI SQL compliant and integrates with popular BI & visualization tools. Drill is included in the MapR Converged Platform as part of MapR Ecosystem Pack (MEP)


Apache Drill integration with MapR Converged Platform enables self-service BI/SQL analytics on operational and historical data.



Apache Drill with Tableau (Video)

Apache Drill Best Practices from the MapR Drill Team (Article) 

4 Ways to Scale Interactive BI and Analytics for a Data Lake (Webinar)




Information Week: 25 Data & Analytics Vendors at the Forefront in 2018

Hitachi Develops FPGA Accelerator for Apache Drill

MapR-DB gets Secondary Indexes to Drive Operational Analytics

How to Explore Data Sets Simultaneously with Oracle Data Visualization

R Interface to Apache Drill Now on CRAN 

Rolling your Own Jupyter and RStudio Data Analysis Environment around Apache Drill 

Superset Integration with Apache Drill

MapR Announces Availability of Native Tableau Connector for Apache Drill



MapR engineers contribute to Apache Drill. Check out the latest activity or ask a question by subscribing to the user and dev mailing lists here. Check out the Apache Drill website and documentation.




Download Drill on MapR Sandbox here.

Test Drive on AWS here.




Latest release notes are located here




Follow @ApacheDrill 




Find content tagged drill  drill best practiceConnect with Apache Drill experts in the community. Want to be included in this list? Add drill as a skill on your user profile. Learn here how.





Introduction to Apache Drill (Video)

Top 10 Reasons to use Apache Drill

Drill 101: Basics of Apache Drill (Video)

Drill 201: Hands-on Tutorial (Video)

How Drill Connects to Data Sources (Video)

How to Turn Raw Data into Insights with Apache Drill (Video)

Resolving Schema Changes with Apache Drill and Python

SQL Query on Mixed Schema Data Using Apache Drill


Data Source Connectivity

How Drill Connects to Data Sources (Video)

Query CSV Data in Amazon S3 with Apache Drill (Video)


BI/Visualization Tool Connectivity

How to Deploy Drill and Connect to BI Tools (Video)

Apache Drill with Tableau (Video)

Apache Drill with MicroStrategy (Video)

Apache Drill with SAP Lumira (Video)

TIBCO Spotfire with Apache Drill (Video)

Essential Tips for Using Apache Drill with OBIEE 12c  

How to Query Apache Drill Using Zeppelin

Using JReport with Apache Drill

XML Plugin for Apache Drill

Configuring Drill Client (ODBC/JDBC) Security with MapR 6.0.x 


Drill Internals

Apache Drill Architecture: The Ultimate Guide

Apache Drill Execution Capabilities (Video)

Apache Drill SQL Queries on Parquet Data (Video)

Drill Configuration Options (Video)

Apache Drill Best Practices from the MapR Drill Team



Redefining SQL-on-Hadoop (Video)

Evolution of Business Intelligence and Self-Service Analytics (Video)

Enabling High-Performance SQL with a JSON Data Model (Video)

Twitter Analytics with Apache Drill (Video)

Social Media Analysis with Apache Drill and MicroStrategy

The Fine Art of Customer Surveys Using Apache Drill

Identify Data Breach with Apache Drill

Using Apache Drill REST API to Build ASCII Dashboard with Node

Jumpstart your Data Warehouse Optimization

ETL and Interactive Analytics with Apache Spark and Apache Drill (Video)




Introduction to Apache Drill

Easy Real-time Access to Data with Apache Drill

4 Ways to Scale Interactive BI and Analytics for a Data Lake

Lessons Learnt from Putting Apache Drill in Production

ESS 400: Apache Drill Essentials

Introduction to SQL Analytics with Apache Drill

Apache Drill Performance and Debugging

MCDA – MapR Certified Data Analyst




BI and Analytics on a Data Lake: The Definitive Guide

Geo-Distribution of Big Data and Analytics

Sharing Big Data Safely

Real World Hadoop

Hadoop Buyer's Guide