Menu
Documentation
Community
FAQ
Blog
Download

Getting Started

Drill Introduction
Why Drill

Architecture

Architecture Introduction
Core Modules
Architectural Highlights

Flexibility
Performance

Tutorials

Tutorials Introduction
Drill in 10 Minutes
Analyzing the Yelp Academic Dataset
Learn Drill with the MapR Sandbox

About the MapR Sandbox
Installing the Apache Drill Sandbox
Getting to Know the Drill Sandbox
Lession 1: Learn about the Data Set
Lession 2: Run Queries with ANSI SQL
Lession 3: Run Queries on Complex Data Types
Summary

Analyzing Highly Dynamic Datasets

Install Drill

Install Drill Introduction
Deploying Drill in a Cluster
Installing Drill in Embedded Mode

Embedded Mode Prerequisites
Installing Drill on Linux
Installing Drill on Mac OS X
Installing Drill on Windows

Installing Drill in Distributed Mode

Connect a Data Source

Connect a Data Source Introduction
Storage Plugin Registration
Storage Plugin Configuration

Plugin Configuration Introduction
Workspaces
File System Storage Plugin
HBase Storage Plugin
Hive Storage Plugin
Drill Default Input Format

MongoDB Plugin for Apache Drill
MapR-DB Format

ODBC/JDBC Interfaces

Interfaces Introduction
Using JDBC
Using ODBC on Linux and Mac OS X

ODBC on Linux and Mac Introduction
Installing the Driver on Linux
Installing the Driver on Mac OS X
Configuring Connections on Linux and Mac OS X
Driver Configuration Options
Using a Connection String
Advanced Properties
Testing the ODBC Connection

Using ODBC on Windows

Installing the Driver on Windows
Configuring Connections on Windows
Connecting to ODBC Data Sources
Tableau Examples
Using Drill Explorer on Windows

Using MicroStrategy Analytics with Drill

Query Data

Query Data Introduction
Querying a File System

Querying a File System Introduction
Querying JSON Files
Querying Parquet Files
Querying Plain Text Files
Querying Directories

Querying HBase
Querying Complex Data

Querying Complex Data Introduction
Sample Data: Donuts
Selecting Flat Data
Using SQL Functions, Clauses, and Joins
Selecting Nested Data for a Column
Selecting Multiple Columns Within Nested Data

Querying Hive
Querying the INFORMATION SCHEMA
Querying System Tables

SQL Reference

SQL Reference Introduction
Data Types

Supported Data Types
Date, Time, and Timestamp
Handling Different Data Types

Lexical Structure
Operators
SQL Functions

About SQL Function Examples
Math and Trig
Data Type Conversion
Date/Time Functions and Arithmetic
String Manipulation
Aggregate and Aggregate Statistical
Functions for Handling Nulls

Nested Data Functions

Nested Data Limitations
FLATTEN
KVGEN
REPEATED_COUNT
REPEATED_CONTAINS

Query Directory Functions
SQL Commands

Supported SQL Commands
ALTER SESSION Command
ALTER SYSTEM Command
CREATE TABLE AS (CTAS) command
CREATE VIEW command
DESCRIBE Command
EXPLAIN commands
SELECT Statements
SHOW DATABASES AND SHOW SCHEMAS Command
SHOW FILES Command
SHOW TABLES Command
USE Command

SQL Conditional Expressions

CASE

Reserved Keywords
SQL Extensions

Data Sources and File Formats

Data Sources and File Formats Introduction
Hive-to-Drill Data Type Mapping
Deploying and Using a Hive UDF
Parquet Format
JSON Data Model

Develop Custom Functions

Develop Custom Functions Introduction
Develop a Simple Function
Developing an Aggregate Function
Adding Custom Functions to Drill
Using Custom Functions in Queries
Custom Function Interfaces

Manage Drill

Manage Drill Introduction
Configuring Drill in a Dedicated Cluster
Configuring a Multitenant Cluster

Configuring a Multitenant Cluster Introduction
Configuring Multitenant Resources
Configuring Resources for a Shared Drillbit

Configuration Options

Configuration Options Introduction
Start-Up Options
Planning and Execution Options
Persistent Configuration Storage

Starting/Stopping Drill
Ports Used by Drill
Partition Pruning
Monitoring and Canceling Queries in the Drill Web UI

Developer Information

Develop Drill

Compiling Drill from Source
Drill Patch Review Tool

Contribute to Drill

Apache Drill Contribution Guidelines
Apache Drill Contribution Ideas

Design Docs

Drill Plan Syntax
RPC Overview
Query Stages
Useful Research
Value Vectors

Release Notes

Apache Drill 0.5.0 Release Notes
Apache Drill 0.4.0 Release Notes
Apache Drill M1 Release Notes (Apache Drill Alpha)
Apache Drill M1 Release Notes (Apache Drill Alpha)
Apache Drill 0.6.0 Release Notes
Apache Drill 0.7.0 Release Notes
Apache Drill 0.8.0 Release Notes

Sample Datasets

AOL Search
Enron Emails
Wikipedia Edit History

Archived Pages

How to Run the Drill Demo
What is Apache Drill

Progress Reports

2014 Q1 Drill Report

Project Bylaws

Manage Drill

Manage Drill

Manage Drill Introduction
Configuring Drill in a Dedicated Cluster
Configuring a Multitenant Cluster

Configuring a Multitenant Cluster Introduction
Configuring Multitenant Resources
Configuring Resources for a Shared Drillbit

Configuration Options

Configuration Options Introduction
Start-Up Options
Planning and Execution Options
Persistent Configuration Storage

Starting/Stopping Drill
Ports Used by Drill
Partition Pruning
Monitoring and Canceling Queries in the Drill Web UI

← Custom Function InterfacesManage Drill Introduction →

Copyright © 2012-2014 The Apache Software Foundation, licensed under the Apache License, Version 2.0.
Apache and the Apache feather logo are trademarks of The Apache Software Foundation. Other names appearing on the site may be trademarks of their respective owners.