Versatility and Functionality of ApacheDrill - Misha Isran, Monty Rahman
Channel: The ASF
Date: 2021-10-10

Thank you to all of of our ApacheCon@Home 2021 sponsors, including:

STRATEGIC
---------------
Google

PLATINUM
--------------
Apple
Huawei
Instaclustr
Tencent Cloud

GOLD
-----------
Aiven OY
AWS
Baidu
Cerner
Didi Chuxing
Dremio
Fiter
Gradle
Red Hat
Replicated Versatility and Functionality of ApacheDrill - Misha Isran, Monty Rahman

A presentation from ApacheCon@Home 2021
https://apachecon.com/acah2021

One of the largest contributing factors to Apache Drill’s success is it’s open-source SQL query engine. Apache Drill possessing an open-source framework allows its community base the ability to continually improve and advance the software to adapt to the constantly evolving data science needs via UDFs (User-Defined Functions). The two clearest examples that come to mind are from our own experience here at Datadistillr where phone numbers and Geo Information System (GIS) functions proved to be of high value. In the case of GIS, we utilized the ST_Point and ST_Distance functions to identify the longitude and latitude coordinates of the International Space Station, convert these into a ST_Point, and return animal-focused charities within a defined radius. 
In another instance, when presented with the task of conducting data analytics on a dataset requiring the information to be fused with external sources, new UDFs had to be created to complete the task of standardizing the format of messy, phone numbers data.
If given the opportunity to speak at ApacheCon we will share how we moved forward towards our finish line of creating a machine learning model that all began with Apache Drill. We will discuss the problems that Apache Drill may solve for its users, the actions that users may take to achieve similar results, and the concepts and science behind the software.