-
Lesson 4 - Apache Drill Architecture
-
Quiz 4
-
Lesson 5 - Apache Drill Query Plans and Optimization
-
Quiz 5
-
Lesson 6 - Apache Drill Performance and Debugging
-
Quiz 6
- Course Materials
-
Slide Guide (Transcript)
-
Lab Guide
-
Lab Environment Connection Guide
Apache Drill Performance and Debugging
In this course, you will write SQL queries on a variety of data types, including structured data in a Hive table, semi-structured data in HBase or MapR-DB, and complex data file types such as Parquet and JSON. You will also learn the different services involved at each step, and how Drill optimizes a query for distributed SQL execution.
What's Covered
| Course Lessons | Lab Activities |
|
4: Apache Drill Architecture Drill Execution ProcessDrill Architecture Components |
Order Query Process Steps Sketch Drillbit Architecture |
|
5: Query Plans and Optimization About Physical Query PlansExamine a Physical Query Plan Optimize Queries |
Examine Physical Query Plans Create a Partitioned Table |
|
6: Apache Drill Performance and Debugging Analyze Drill Error MessagesConfigure Log File Settings Troubleshoot Apache Drill |
Examine Drill Log Files |
Get Certified
This course is part of the preparation for the MapR Certified Data Analyst (MCDA) certification exam.
Prerequisites
- Completion of the MapR Academy on-demand courses: ESS 100 - 102, and DA 400
- Linux skills, including familiarity with command-line options such as ls, cd, cp, and su
- Beginning to intermediate proficiency with SQL
- Basic Hadoop knowledge