Course Outline

Introduction to Apache Drill

How does Apache Drill compare to Spark SQL, Hive and Impala?

Overview of Apache Drill Features and Architecture

  • Apache Drill Components

Understanding Apache Drill Queries

  • Query Execution Process

Performing SQL Queries

  • Connecting to the data source
  • Querying the data

Using the Drill Web Console

  • Query, Profiles, Storage, Metrics, Threads, and Options

Performance Optimization Strategy

  • Identifying the source of performance issues
  • Analyzing Query Plans and Profiles

Apache Drill Query Optimization

  • Optimizing a Query

Limiting the Data that Drill Reads

  • Partitioning the data (partition pruning)

Apache Drill Logging and Debugging

  • Analyzing Drill Error Messages
  • Configuring Log File Options

Troubleshooting Apache Drill

Summary and Conclusion


  • An understanding of Hadoop, NoSQL, and other data storage concepts
  • A general understanding of SQL queries
  • Experience with Linux command line
  7 Hours


Related Courses

Apache Drill

  21 hours

Apache Drill Performance Optimization and Debugging

  7 hours

Big Data Business Intelligence for Govt. Agencies

  35 hours

From Data to Decision with Big Data and Predictive Analytics

  21 hours

Big Data Architect

  35 hours

Programming with Big Data in R

  21 hours

Big Data Storage Solution - NoSQL

  14 hours

Big Data & Database Systems Fundamentals

  14 hours

Data Science for Big Data Analytics

  35 hours

A Practical Introduction to Data Analysis and Big Data

  35 hours

Vespa: Serving Large-Scale Data in Real-Time

  14 hours

Big Data Analytics for Telecom Regulators

  14 hours

Big Data Business Intelligence for Criminal Intelligence Analysis

  35 hours

Big Data - Data Science

  14 hours

Big Data and its Management Process

  14 hours