Apache Drill : Self-Service Data Exploration and Nested Data Analytics on Hadoop

SQL is one of the most widely used languages to access, analyze, and manipulate structured data. As Hadoop gains traction within enterprise data architectures across industries, the need for SQL for both structured and loosely-structured data on Hadoop is growing rapidly Apache Drill started off with the audacious goal of delivering consistent, millisecond ANSI SQL query capability across wide range of data formats. At a high level, this translates to two key requirements – Schema Flexibility and Performance.

Apache Drill provides the users the ability to interact with big data on Hadoop much faster and far more easily using the familiar SQL language. Users are no longer dependent on central IT teams and DBAs to produce schemas and then maintain them when the structure changes for a few records. Drill alleviates the pain associated with structuring unstructured data before one gains any insights by providing a simple mechanism to query any dataset on Hadoop - be it flat files, parquet or JSON files or tables within an HBase table.

This session will give you an overview of several different use cases that enterprises are testing Drill for.

David Kim from Cardlytics will present on their use of Apache Drill in production.

Brandon Newell from MapR will present on the basics of Drill and how to get started using it.

Event will be recorded and posted after editing.

Parking Instructions:

It is most convenient if you enter the parking lot on the North Ave side of the building (across the street from Southern Dairies), park in the surface lot (lot that you pull into from the street) and if you are facing the building (from North Ave) walk down the right side of the building towards the flats entrance, pass the flats entrance and you will dead end into the lobby for the suites. Please sign in in the lobby, take the elevator to the sixth floor and you will see our front (blue) doors upon exiting. Amber will be at the front desk to greet you and she will inform the appropriate parties that you have arrived on site. Please write down my contact information should you have any questions upon arriving on site.

Food will be provided by D.B.A. BBQ