Menu
Documentation
Community
FAQ
Blog
Download

Getting Started

Drill Introduction
Why Drill

Architecture

Architecture Introduction
Drill Query Execution
Core Modules
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
Lesson 1: Learn about the Data Set
Lesson 2: Run Queries with ANSI SQL
Lesson 3: Run Queries on Complex Data Types
Summary

Analyzing Highly Dynamic Datasets
Analyzing Social Media
Analyzing Data Using Window Functions

Install Drill

Install Drill Introduction
Migrating Parquet Data
Installing Drill in Embedded Mode

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

Installing Drill in Distributed Mode

Distributed Mode Prerequisites
Installing Drill on the Cluster
Starting Drill in Distributed Mode

Starting the Web Console

Configure Drill

Configure Drill Introduction
Configuring Drill Memory
Configuring a Multitenant Cluster

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

Configuring User Impersonation
Configuring User Authentication
Configuring User Impersonation with Hive Authorization
Configuring Web Console and REST API Security
Configuration Options

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

Ports Used by Drill
Configuring the Drill Shell

Connect a Data Source

Connect a Data Source Introduction
Storage Plugin Registration
Storage Plugin Configuration

Plugin Configuration Basics
Workspaces
Drill Default Input Format

File System Storage Plugin
HBase Storage Plugin
Hive Storage Plugin
RDBMS Storage Plugin
MongoDB Storage Plugin
S3 Storage Plugin

ODBC/JDBC Interfaces

Interfaces Introduction
Using the JDBC Driver
Using JDBC with SQuirreL on Windows
Installing the ODBC Driver

Installing the Driver on Linux
Installing the Driver on Mac OS X
Installing the Driver on Windows
Installing the TDC File on Windows

Configuring ODBC

ODBC Configuration Reference
Configuring ODBC on Linux
Configuring ODBC on Mac OS X
Configuring ODBC on Windows
Testing the ODBC Connection

Using Drill Explorer

Drill Explorer Introduction
Connecting Drill Explorer to Data
Browsing Data and Defining Views

Using Drill with BI Tools

Using Drill with BI Tools Introduction
Tableau Examples
Using MicroStrategy Analytics with Apache Drill
Using Tibco Spotfire Desktop with Drill
Configuring Tibco Spotfire Server with Drill
Using Qlik Sense with Drill
Using Apache Drill with Tableau 9 Desktop
Using Apache Drill with Tableau 9 Server
Configuring JReport 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 Sequence Files

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
Monitoring and Canceling Queries in the Drill Web Console

Performance Tuning

Performance Tuning Introduction
Partition Pruning

Partition Pruning Introduction
How to Partition Data

Optimizing Parquet Metadata Reading
Choosing a Storage Format
Query Plans and Tuning

Query Plans and Tuning Introduction
Join Planning Guidelines
Guidelines for Optimizing Aggregation
Modifying Query Planning Options
Sort-Based and Hash-Based Memory-Constrained Operators
Enabling Query Queuing
Controlling Parallelization to Balance Performance with Multi-Tenancy

Identifying Performance Issues

Query Plans
Query Profiles

Performance Tuning Reference

Query Profile Column Descriptions
Physical Operators

Log and Debug

Log and Debug Introduction
Error Messages
Modify logback.xml
Review the Java Stack Trace
Query Audit Logging

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

SQL Window Functions

SQL Window Functions Introduction
Aggregate Window Functions
Ranking Window Functions
Value Window Functions
SQL Window Functions Examples

Nested Data Functions

Nested Data Limitations
FLATTEN
KVGEN
REPEATED_COUNT
REPEATED_CONTAINS

Query Directory Functions
SQL Commands

Supported SQL Commands
SET
RESET
ALTER SYSTEM
CREATE TABLE AS (CTAS)
PARTITION BY Clause
CREATE VIEW
DESCRIBE
DROP TABLE
DROP VIEW
EXPLAIN
SELECT
SELECT List
FROM Clause
GROUP BY Clause
HAVING Clause
LIMIT Clause
OFFSET Clause
ORDER BY Clause
UNION Set Operator
WHERE Clause
WITH Clause
SHOW DATABASES and SHOW SCHEMAS
SHOW FILES
SHOW TABLES
USE

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
Text Files: CSV, TSV, PSV
Sequence Files

Develop Custom Functions

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

Troubleshooting
Developer Information

REST API
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 1.4.0 Release Notes
Apache Drill 1.3.0 Release Notes
Apache Drill 1.2.0 Release Notes
Apache Drill 1.1.0 Release Notes
Apache Drill 1.0.0 Release Notes
Apache Drill 0.9.0 Release Notes
Apache Drill 0.8.0 Release Notes
Apache Drill 0.7.0 Release Notes
Apache Drill 0.6.0 Release Notes
Apache Drill M1 Release Notes (Apache Drill Alpha)
Apache Drill M1 Release Notes (Apache Drill Alpha)
Apache Drill 0.5.0 Release Notes
Apache Drill 0.4.0 Release Notes

Sample Datasets

AOL Search
Enron Emails
Wikipedia Edit History

Project Bylaws

SQL Functions

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

← OperatorsAbout SQL Function Examples →

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.