Apache Calcite

{{Short description|Open-source data management framework}}

{{Infobox software

| name = Apache Calcite

| logo = File:Apache Calcite Logo.svg

| screenshot =

| caption =

| developer = Apache Software Foundation

| released = {{Start date and age|2014|06|27}}{{cite web |url=https://mail-archives.apache.org/mod_mbox/optiq-dev/201406.mbox/%3CCABivuanCAHphdi4U3UC+b3c0OZt+dBk+HVVWBREex191SnXyxw@mail.gmail.com%3E |title=Optiq-0.8 release announcement|author=Julian Hyde|publisher=Apache Software Foundation}}

| latest release version =

| latest release date =

| latest preview version =

| latest preview date =

| operating system = Cross-platform

| repo = {{URL|https://github.com/apache/calcite.git|Calcite Repository}}

| programming language = Java

| platform = Java

| genre = SQL database framework

| license = Apache License 2.0

| website = {{URL|https://calcite.apache.org/}}

}}

{{Portal|Free and open-source software}}

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.{{cite web |url=http://calcite.apache.org/docs/powered_by.html|title=Powered by Calcite|publisher=Apache Software Foundation}}

Hive uses Calcite for cost-based query optimization;Julian Hyde. [http://www.slideshare.net/julianhyde/costbased-query-optimization-in-apache-hive-014 "Cost-based query optimization in Apache Hive 0.14"], [http://www.hortonworks.com Hortonworks], 24 September 2014.

Drill and Kylin use Calcite for SQL parsing and optimization;

Samza and Storm use Calcite for streaming SQL.

{{As of|2016|8}}, Apex, Phoenix and Flink have projects under development that use Calcite.