Data Exploration with Apache Drill

Prerequisites

Drill uses standard ANSI SQL as its main user interface. This course focuses on how to use Drill and not the details of SQL syntax so having a good understanding of SQL will help you with this class. If you are looking for a good tutorial, I recommend SQL for Mere Mortals by John Viescas and Michael J. Hernandez which is available here: http://amzn.to/2lfhXNL.

Required Software

For this class, I will provide you with a virtual machine with Drill and all the required software pre-configured. I highly recommend using the virtual machine. The virtual machine needs 8GB of RAM and 30GB of hard disk space. You will also need to:

• Download and install Virtualbox
• Download and unzip the Griffon virtual machine here: https://github.com/gtkcyber/griffon-vm (You'll need 7-zip to unzip the VM)

If you are not using the VM, you will need to install Drill on your local machine.

Links

• Apache Drill website
• Official Drill Documentation

Instructor

Charles Givre has always been interested solving problems in unique ways, and has worked to make a career of it as a data scientist at Booz Allen Hamilton. At Booz Allen, Mr. Givre worked as a technical leader on various large government projects. Mr. Givre enjoys sharing his passion for data science with others and has worked to develop comprehensive data science training programs at his firm. Prior to joining Booz Allen, Mr. Givre worked as a counterterrorism analyst at the Central Intelligence Agency for nearly five years.

Mr. Givre got interested in Apache Drill several years ago, and is co-author of the first O’Reilly book about Drill. He has delivered numerous workshops about Drill and has contributed to the codebase. Mr. Givre is a sought-after speaker and has delivered training and talks at international conferences such as BlackHat, Strata + Hadoop World, Open Data Science Conference (ODSC) and others. Mr. Givre holds a Master of Arts from Brandeis University in Middle Eastern Studies, a Bachelor of Science in Computer Science and a Bachelor of Music both from the University of Arizona. Mr. Givre also holds a CISSP, Security+ and various other certifications. Mr. Givre blogs at thedataist.com and in his non-existant spare time, Mr. Givre enjoys spending time with his family and restoring classic cars.

Code of Conduct

Since this is an official O'Reilly Training, we will adhere to the O'Reilly conferences Code of Conduct.

"At O'Reilly, we assume that most people are intelligent and well-intended, and we're not inclined to tell people what to do. However, we want every O'Reilly conference to be a safe and productive environment for everyone. To that end, this code of conduct spells out the behavior we support and don't support at conferences."