• Menu
  • Language
    • en
    • zh
  • Apache
  • Powered By
  • Documentation
    • Getting Started
    • Architecture
    • Tutorials
    • Drill-on-YARN
    • Install Drill
    • Configure Drill
    • Connect a Data Source
    • ODBC/JDBC Interfaces
    • Query Data
    • Performance Tuning
    • Log and Debug
    • SQL Reference
    • Data Sources and File Formats
    • Develop Custom Functions
    • Troubleshooting
    • Developer Information
    • Release Notes
    • Sample Datasets
    • Project Bylaws
    • Ecosystem
  • Community
    • Team
    • Mailing Lists
    • Community Resources
  • FAQ
  • Blog
  • twitter logo
  • Slack logo
  • 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
    • Orchestrating queries with Airflow
  • Drill-on-YARN
    • Drill-on-YARN Introduction
    • Creating a Basic Drill Cluster
    • Launch Drill Under YARN
    • Configuration Reference
    • Drill-on-YARN Command-Line Tool
    • Using the Drill-on-YARN Web UI
    • Multiple Drill Clusters
    • Enabling Web UI Security
    • Appendix A: Release Note Issues
    • Appendix B: drill-env.sh Settings
    • Appendix C: Troubleshooting
    • Appendix D: Recreate the Drill Archive
  • Install Drill
    • Install Drill Introduction
    • Migrating Parquet Data
    • Installing Drill in Embedded Mode
      • Embedded Mode Prerequisites
      • Running Drill on Docker
      • 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 UI
    • Stopping Drill
    • Identifying Multiple Drill Versions in a Cluster
    • Extended
      • Installing Drill in Distributed Mode with GCP Dataproc
  • Configure Drill
    • Configure Drill Introduction
    • Configuring Drill Memory
    • Securing Drill
      • Securing Drill Introduction
      • Secure Communication Paths
      • Roles and Privileges
      • Configuring User Impersonation
      • Configuring Inbound Impersonation
      • Configuring User Impersonation with Hive Authorization
      • Configuring User Security
      • Configuring Plain Security
      • Configuring SSL/TLS for Encryption
      • Using libpam4j as the PAM Authenticator
      • Using jpam as the PAM Authenticator
      • Configuring htpasswd file authentication
      • Configuring HashiCorp Vault authentication
      • Configuring Kerberos Security
      • Configuring Drill to use SPNEGO for HTTP Authentication
      • Configuring Web UI and REST API Security
      • Configuring Custom ACLs to Secure znodes
    • 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
      • Global Query List
    • Ports and Bind Addresses Used by Drill
    • Configuring the Drill Shell
    • Configuring cgroups to Control CPU Usage
  • Connect a Data Source
    • Connect a Data Source Introduction
    • Storage Plugin Registration
    • Storage Plugin Configuration
      • Plugin Configuration Basics
      • Configuring Storage Plugins
      • Storage plugin authentication modes
      • Workspaces
      • Drill Default Input Format
    • File System Storage Plugin
    • HBase Storage Plugin
    • Hive Storage Plugin
    • RDBMS Storage Plugin
    • MongoDB Storage Plugin
    • MapR-DB Format
    • S3 Storage Plugin
    • OCI OS Storage Plugin
    • OpenTSDB Storage Plugin
    • Kafka Storage Plugin
    • Azure Blob Storage Plugin
    • Druid Storage Plugin
    • HTTP Storage Plugin
    • ElasticSearch Storage Plugin
    • Splunk Storage Plugin
    • Cassandra Storage Plugin
    • Dropbox Storage Plugin
    • Google Sheets 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
    • Configuring ODBC
      • ODBC Configuration Reference
      • Logging and Tracing
      • 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 10.2
      • Using Apache Drill with Tableau 9 Desktop
      • Using Apache Drill with Tableau 9 Server
      • Using Information Builders’ WebFOCUS with Apache Drill
      • Configuring JReport with Drill
  • Query Data
    • Query Data Introduction
    • Querying a File System
      • Querying a File System Introduction
      • Querying Avro Files