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

February 21, 2018
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
High-Performance Cloud-Native APIs Using Apache Geode - Anna Jung Paul Vermeulen
High-Performance Cloud-Native APIs Using Apache Geode - Anna Jung Paul Vermeulen

Traditionally cloud native APIs contain the logic to convert data from repositories into information. As th...

Next Video
Apache Geode: How Pymma Uses it as a Efficient Alternative to Kafka-Storm-Spark - Paul Perez
Apache Geode: How Pymma Uses it as a Efficient Alternative to Kafka-Storm-Spark - Paul Perez

Further to our customers request, we had to implement a fine monitoring system for the OpenESB business pro...