Enable SQL/JDBC Access to Apache Geode/GemFire Using Apache Calcite - Christian Tzolov

December 18, 2017

When working with BigData & IoT systems we often feel the need for an established, Common Query Language. To fill this gap some NoSql vendors are building SQL access to their systems. Building SQL engine from scratch is a daunting job and frameworks like Apache Calcite can help you with the heavy lifting. It allows you to integrate SQL parser, Cost-Based Optimizer, and JDBC with your NoSql system. Calcite has been used to empower many BigData platforms such as Hive, Spark, Flink, Drill, HBase/Phoenix to name some. In this session I will walk you through the process of building a SQL access layer for Apache Geode (GemFire). I will share my experience, pitfalls and technical consideration like balancing between the SQL/RDBMS semantics and the design choices and limitations of In-Memory-Data-Grid systems like Geode. Hopefully this will enable you to add SQL capabilities to your preferred NoSQL data system. Christian Tzolov, Software Craftsman, Pivotal Recorded at SpringOne Platform 2017.

Previous
T-Mobile & Pivotal
T-Mobile & Pivotal

Hear from Brendan Aye at T-Mobile about how the wireless carrier was able to stay 100% available during the...

Next Video
Real-Time Analytics for Data-Driven Applications - Milind Bhandarkar
Real-Time Analytics for Data-Driven Applications - Milind Bhandarkar

To provide hyper-personalized digital experiences in the emerging market transformation, innovative enterpr...