Thank you for sending your enquiry! One of our team member will contact you shortly.
Thank you for sending your booking! One of our team member will contact you shortly.
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
The content, as I found it very interesting and think it would help me in my final year at University.
Krishan Mistry - NBrown Group
Richard's training style kept it interesting, the real world examples used helped to drive the concepts home.
Jamie Martin-Royle - NBrown Group
I generally liked the fernando's knowledge.
Valentin de Dianous - Informatique ProContact INC.
The subject matter and the pace were perfect.
Tim - Ottawa Research and Development Center, Science Technology Branch, Agriculture and Agri-Food Canada
The tutor, Mr. Michael Yan, interacted with the audience very well, the instruction was clear. The tutor also go extent to add more information based on the requests from the students during the training.
Ottawa Research and Development Center, Science Technology Branch, Agriculture and Agri-Food Canada
the introduction of new packages
Ottawa Research and Development Center, Science Technology Branch, Agriculture and Agri-Food Canada
Michael the trainer is very knowledgeable and skillful about the subject of Big Data and R. He is very flexible and quickly customize the training to meet clients' need. He is also very capable to solve technical and subject matter problems on the go. Fantastic and professional training!
Xiaoyuan Geng - Ottawa Research and Development Center, Science Technology Branch, Agriculture and Agri-Food Canada
The broad coverage of the subjects
- Roche
Intensity, Training materials and expertise, Clarity, Excellent communication with Alessandra
Marija Hornis Dmitrovic - Marija Hornis
The example and training material were sufficient and made it easy to understand what you are doing
Teboho Makenete
I liked the way that my trainer was teaching us, and the Meeting Room was taken for our course.
Mohammed Othman Karim, Sulaymaniyah Asayish Agency
Interactive topics and the style used by the lecture to simplified the topics for the students
Miran Saeed - Mohammed Othman Karim, Sulaymaniyah Asayish Agency
Smart and cleverness
Mohammed Othman Karim, Sulaymaniyah Asayish Agency
the trainer and his ability to lecture
ibrahim hamakarim - Mohammed Othman Karim, Sulaymaniyah Asayish Agency
Practical exercises
JOEL CHIGADA - University of the Western Cape
R programming
Osden Jokonya - University of the Western Cape
Overall the Content was good.
Sameer Rohadia
presentation of technologies
Continental AG / Abteilung: CF IT Finance
Willingness to share more
Balaram Chandra Paul
trainer's knowledge
Fatma Badi - Maitha Jamal Alshamsi, Dubai Electricity & Water Authority
Related Courses
Apache Drill
21 hours
Apache Drill Query Optimization
7 hours
Big Data Architect
35 hours
Programming with Big Data in R
21 hours
Big Data Storage Solution - NoSQL
14 hours
Data Science for Big Data Analytics
35 hours
Big Data - Data Science
14 hours
Big Data and its Management Process
14 hours