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
Requirements
- A general understanding of Hadoop
- Experience with Linux command line
Testimonials (7)
- Paktyczne zastosowanie tematyki szkolenia, - doświadczenie i duża widza, - udzielanie odpwiedzi na zadawane pytania w rozumiały i jasny sposób.
Magdalena Zabielska - Wyższa Szkoła Bankowa w Poznaniu
Course - Machine Learning and Big Data
I genuinely enjoyed the many hands-on sessions.
Jacek Pieczątka
Course - Administrator Training for Apache Hadoop
I generally liked the fernando's knowledge.
Valentin de Dianous - Informatique ProContact INC.
Course - Big Data Architect
The subject matter and the pace were perfect.
Tim - Ottawa Research and Development Center, Science Technology Branch, Agriculture and Agri-Food Canada
Course - Programming with Big Data in R
How big data work, data programs, greater knowledge of how our current world works using data
Ozayr Hussain - Vodacom
Course - A Practical Introduction to Data Analysis and Big Data
The content, as I found it very interesting and think it would help me in my final year at University.
Krishan - NBrown Group
Course - From Data to Decision with Big Data and Predictive Analytics
Intensity, Training materials and expertise, Clarity, Excellent communication with Alessandra