An introduction to Apache Drill

1
Apache Drill

• What is it ?
• How does it work ?
• Interfaces
• Architecture

www.semtech-solutions.co.nz info_at_semtech-solutions
.co.nz
2
Apache Drill What is it ?

• Interactive Analysis
• Like Google Dremel
• Designed for Big Data
• Fast low latency queries
• Complements existing tools like Pig, Hive, Map
  Reduce
• Licensed via Apache
• Distributed
• Query planning
• Scheduling
• Execution

www.semtech-solutions.co.nz info_at_semtech-solutions
.co.nz
3
Apache Drill Interfaces

• User Interfaces
• REST
• CLI ( command line )?
• Native API
• JDCB / ODBC

www.semtech-solutions.co.nz info_at_semtech-solutions
.co.nz
4
Apache Drill Interfaces

• Processing Interfaces
• SQL
• DrQL ( Drill query language )?
• MongoQL
• DSL

www.semtech-solutions.co.nz info_at_semtech-solutions
.co.nz
5
Apache Drill Interfaces

• Data Interfaces
• Cassandra
• Hbase
• Hadoop HDFS
• MongoDB
• RDBMS
• ( pluggable data sources )?

www.semtech-solutions.co.nz info_at_semtech-solutions
.co.nz
6
Apache Drill Architecture
www.semtech-solutions.co.nz info_at_semtech-solutions
.co.nz
7
Apache Drill Architecture
www.semtech-solutions.co.nz info_at_semtech-solutions
.co.nz
8
Contact Us

• Feel free to contact us at
• www.semtech-solutions.co.nz
• info_at_semtech-solutions.co.nz
• We offer IT project consultancy
• We are happy to hear about your problems
• You can just pay for those hours that you need
• To solve your problems