Apache Calcite Explained

Apache Calcite
Developer:Apache Software Foundation
Released:[1]
Operating System:Cross-platform
Programming Language:Java
Genre:SQL database
License:Apache License 2.0

Apache Calcite is an open source framework for building databases and data management systems. It includes a SQL parser, an API for building expressions in relational algebra, and a query planning engine.As a framework, Calcite does not store its own data or metadata, but instead allows external data and metadata to be accessed by means of plug-ins.

Several other Apache projects use Calcite.[2] Hive uses Calcite for cost-based query optimization;[3] Drill and Kylin use Calcite for SQL parsing and optimization;Samza and Storm use Calcite for streaming SQL., Apex, Phoenix and Flink have projects under development that use Calcite.

Notes and References

  1. Web site: Optiq-0.8 release announcement. Julian Hyde. Apache Software Foundation.
  2. Web site: Powered by Calcite. Apache Software Foundation.
  3. Julian Hyde. "Cost-based query optimization in Apache Hive 0.14", Hortonworks, 24 September 2014.