Enable SQL/JDBC Access to Apache Geode/GemFire Using Apache Calcite

December 20, 2017

SpringOne Platform 2017 Christian Tzolov, Pivotal "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."

Spring Driven Industrial IoT Utilizing Edge, Fog, and Cloud Computing - Barry Wood, RPY Motion & Mark Weislow, Pivotal

During this presentation, you will see a demonstration, including live manufacturing equipment, for an end ...

No More Presentations

Enable SQL/JDBC Access to Apache Geode/GemFire Using Apache Calcite

Previous

Related content in this Stream

Data is the new gold and PaaS solutions like PCF are an abundant source of this increasingly-important resource. This talk will demonstrate the immense value available from a reference architecture de

SpringOne Platform 2017 Pulkit Chandra, Pivotal "One of the most important factors in a microservices architecture is that application logic is separate from the data store. This design choice makes

One of the most important factors in a microservices architecture is that application logic is separate from the data store. This design choice makes it easier for the application to scale. Providing

Ever looked for "data" in the Twelve Factor App manifesto? There is no guidance for how to architect the data layer. And yet, we know how tremendously important data is to an application and an organi

SpringOne Platform 2017 Luke Shannon, Pivotal; John Blum, Pivotal Building complex, transactional and analytical applications at scale, that are highly available, performant, and consistent is challe

During this presentation, you will see a demonstration, including live manufacturing equipment, for an end to end feedback workflow of Industrial Spring IOT: How Spring driven IoT can be utilized to