1841
participiants have registered for our events in 2023

Jonatan Kazmierczak senior consultant at Atos Consulting, creator of Class Visualizer, top rated participant in contests in programming and data science, working with Java and SQL for 20 years.

He started programming at the age of 12 and until now he likes demos from 8-bit Atari XL/XE.

07.02.2017

Efficient Big Data Exploration with SQL and Apache Drill

LOCATION: Zürich
KEYWORDS: Technology, Open Source

AGENDA:18:15 - 19:30h: Talk incl. Q/A
Afterwards you are invited to a refreshment.

SPEAKER: Jonatan Kazmierczak   COMPANY: Atos Consulting
SLIDES: 170207_jk-sql-drill.pdf

We are continuously confronted with increasing volumes of data coming from various sources. We may get it in text formats like JSON, CSV or, for example, as server logs. Sometimes it is compressed or distributed within a tree of subdirectories. We have it also in relational and non-relational data stores. Is it possible to quickly explore all that variety of data directly with SQL without involving expensive and complex infrastructure?

Apache Drill is a low latency distributed schema-free SQL query engine for large-scale datasets, including structured and semi-structured/nested data. Drill is designed to scale to several thousands of nodes and query petabytes of data at the speeds that BI/Analytics environments require. Drill also provides a high performance Java API which can be used to develop custom functions.

This session will give a practical introduction to Apache Drill. During live demos we will dive into querying capabilities across various data formats and sources as well as configuration of the tool. At the end we will be fully prepared to start exploration of our own Big Data with SQL and Apache Drill.

LEVEL OF TALK: Beginner
LANGUAGE: Talk: en / Slides: en


Jonatan Kazmierczak senior consultant at Atos Consulting, creator of Class Visualizer, top rated participant in contests in programming and data science, working with Java and SQL for 20 years.

He started programming at the age of 12 and until now he likes demos from 8-bit Atari XL/XE.


LEVELS:

BEGINNER
The presented topic is new to the audience or only little and superficial experience exists. This talk will mainly cover basic aspects of the topic and not go into much detail.

INTERMEDIATE
The presented topic is known to the audience, serious practical experience is expected. This talk might cover some basic aspects of the topic, but will as well go into depth and details.

ADVANCED
The presented topic is well-known to the audience, serious practical experience and a deep understanding are required. This talk will not cover basics of the topic, but will go into depth, might discuss details, compare different approaches, and so on.

ALL
The topic presented is of interest to all levels and does not require any special prior knowledge.

top

Supporting members

Platin

Gold

Silver

 
 

 

About

JUG Switzerland aims at promoting the application of Java technology in Switzerland.

JUG Switzerland facilitates the sharing of experience and information among its members. This is accomplished through workshops, seminars and conferences. JUG Switzerland supports and encourages the cooperation between commercial organizations and research institutions.

JUG Switzerland is funded through membership fees.

Design
Partner

 

Contact

Java User Group Switzerland
8000 Zürich
info@jug.ch

© Java User Group Switzerland