Apache Calcite Online Meetup January 2021

The main purpose of this meetup is to bring the community together allowing newcomers and senior members to interact and exchange ideas.

During the occasion we will have a few presentations covering introductory Calcite concepts, recent & ongoing work on streams, and spatial query implementation, followed by open discussion and virtual key signing party.

Tentative agenda

Part I: Presentations (2h)

Title: An introduction to query processing & Apache Calcite
Speaker: Stamatis Zampetakis
Duration: ~35min
Abstract:
In this talk, I will go over some basic notions around query processors and demonstrate how they map to concepts in Calcite.
I will start with some simple use-cases and show how from Java code we can go to relational algebra and SQL, explaining the importance of a declarative language and the role of a query processing framework.
Then, I will focus on the query processor, illustrating the general architecture and the main components of Apache Calcite.
After a simple end to end example of the different modules, I will perform a live coding session demonstrating how we can put together the main components of Calcite to build a simple query processor for in-memory data.

Title: Event timestamp semantic based streaming SQL
Speaker: Rui Wang
Duration: ~30 mins
Abstract:
In this talk, I will explain how to reason about data completeness in terms of event timestamp semantics and how to control materialization latency given unbounded input data & streams.

Title: Implementing spatial queries using algebra rewrites
Speaker: Julian Hyde
Duration: 20 mins
Abstract: TBD

Title: Apache Calcite integration in Hazelcast IMDG
Speaker: Vladimir Ozerov
Duration: 30 mins
Abstract:
Hazelcast IMDG is a distributed in-memory key-value store. In this talk, I
will present how we used Apache Calcite to create a new distributed SQL engine that queries Hazelcast IMDG data.
We start with motivation and general design. Then we examine how Hazelcast IMDG leverages Apache Calcite for query parsing, validation, and optimization, and why we decided not to use Apache Calcite for JDBC and query execution. Finally, we present several Apache Calcite problems that negatively affect the integration and propose possible future improvements.

Part II: Open discussion (30m)

Part III: Key signing (30m)
If you plan to attend the key signing session, you must submit your armored public PGP key via the following form till Mon, Jan 18, 2021, 9:00 AM PST (UTC-8) (Key submissions are now closed).

https://forms.gle/p9Kv7oEaFLGzqgvK8

We will use a variation of the Zimmermann protocol (https://en.wikipedia.org/wiki/Zimmermann%E2%80%93Sassaman_key-signing_protocol) to speed up the key signing process.

To verify your identity, please have with you a government issued ID (preferably passport).

The event keyring along with the list of the participants can be found here: https://drive.google.com/drive/folders/1LJl1oYxmrb042CHAAZxK3gTeT0VbtWFz?usp=sharing

The respective checksums are:

5b785e8c5208c705728cc474bc0f2fcce995441ec547e2382acb9daa4d9320f30043709683c626a1ee95c30126ca9b0362e50d153fc65d9ea457cec789bf7419 calcite-meetup-2021-01-20.gpg

d70e977f137543bdbf851d96d3a3437dfb925ae0f5c5c5cab5eba5283c393c9cf7f8d16a1382cb084d74304814d496406ba51c1c206121f465f4b30ffadc0cba keylist.txt

Key-signing resources:
https://www.cryptnet.net/fdp/crypto/keysigning_party/en/keysigning_party.html
https://gist.github.com/F21/b0e8c62c49dfab267ff1d0c6af39ab84
https://wiki.debian.org/DebianTaiwan/MiniDebConf2009/KeySigningParty