Apache Calcite

aid: apache-calcite
name: Apache Calcite
description: Apache Calcite is a dynamic data management framework developed by the Apache Software Foundation that provides
  SQL parsing, query planning and optimization, and data federation capabilities. It serves as the SQL engine and query optimizer
  for many big data systems including Apache Hive, Druid, Flink, Kafka Streams, and others. Calcite provides a Java API for
  embedding SQL capabilities into applications, a JDBC adapter for connecting heterogeneous data sources, and an extensible
  relational algebra framework for building custom query optimizers.
type: Index
position: Consumer
access: 3rd-Party
image: https://kinlane-images.s3.amazonaws.com/shared/apis-json/apis-json-logo.jpg
tags:
- Apache
- Data Federation
- Framework
- Open Source
- Query Optimization
- SQL
created: '2026-03-16'
modified: '2026-04-19'
url: https://raw.githubusercontent.com/api-evangelist/apache-calcite/refs/heads/main/apis.yml
specificationVersion: '0.19'
apis:
- aid: apache-calcite:apache-calcite-java-api
  name: Apache Calcite Java API
  description: The Apache Calcite Java API provides SQL parsing, validation, query planning, and optimization capabilities
    for embedding in JVM applications. It exposes a relational algebra framework and pluggable optimizer rules for building
    custom query engines.
  humanURL: https://calcite.apache.org/docs/
  tags:
  - Java
  - Query Engine
  - SQL
  properties:
  - type: Documentation
    url: https://calcite.apache.org/docs/
  - type: APIReference
    url: https://calcite.apache.org/javadocAggregate/
  - type: GettingStarted
    url: https://calcite.apache.org/docs/tutorial.html
- aid: apache-calcite:apache-calcite-jdbc-api
  name: Apache Calcite JDBC API
  description: The Apache Calcite JDBC adapter provides a standard JDBC interface over heterogeneous data sources. Applications
    use it to issue SQL queries across multiple data formats and storage systems through a unified SQL interface.
  humanURL: https://calcite.apache.org/docs/adapter.html
  tags:
  - JDBC
  - SQL
  properties:
  - type: Documentation
    url: https://calcite.apache.org/docs/adapter.html
  - type: SDKs
    url: https://search.maven.org/artifact/org.apache.calcite/calcite-core
- aid: apache-calcite:apache-calcite-avatica-api
  name: Apache Calcite Avatica API
  description: Apache Avatica is a framework for building database drivers derived from Apache Calcite. It provides a JSON/Protobuf-over-HTTP
    remote protocol for JDBC clients to connect to Calcite-based query engines.
  humanURL: https://calcite.apache.org/avatica/docs/
  tags:
  - Avatica
  - HTTP
  - JDBC
  properties:
  - type: Documentation
    url: https://calcite.apache.org/avatica/docs/
  - type: APIReference
    url: https://calcite.apache.org/avatica/javadocAggregate/
common:
- type: GitHubOrganization
  url: https://github.com/apache
- type: GitHubRepository
  url: https://github.com/apache/calcite
- type: Documentation
  url: https://calcite.apache.org/
- type: GettingStarted
  url: https://calcite.apache.org/docs/tutorial.html
- type: Support
  url: https://calcite.apache.org/community/
- type: TermsOfService
  url: https://www.apache.org/licenses/
- type: ChangeLog
  url: https://github.com/apache/calcite/releases
- type: SDKs
  url: https://search.maven.org/artifact/org.apache.calcite/calcite-core
  title: Java SDK (Maven)
- type: Vocabulary
  url: vocabulary/apache-calcite-vocabulary.yaml
- type: Features
  data:
  - name: SQL Parsing and Validation
    description: Parse and validate SQL queries using an extensible SQL grammar with support for SQL:2003 and beyond.
  - name: Query Optimization
    description: Cost-based and rule-based query optimization using a volcano-style optimizer with pluggable optimization
      rules.
  - name: Relational Algebra
    description: Extensible relational algebra framework for representing and transforming query plans as expression trees.
  - name: Data Federation
    description: Federate queries across heterogeneous data sources including CSV, JSON, JDBC databases, and Elasticsearch.
  - name: Adapter Framework
    description: Pluggable adapter API for connecting new data sources to the Calcite SQL engine.
  - name: Materialized Views
    description: Automatic materialized view recognition and query rewriting for query acceleration.
  - name: Streaming SQL
    description: SQL extensions for querying streaming data sources with window functions and temporal predicates.
  - name: Lattices and Tiles
    description: Summary table recommendation and query rewriting using lattice structures for OLAP workloads.
  - name: JDBC Driver
    description: Standard JDBC driver for issuing SQL queries against Calcite-connected data sources.
  - name: Avatica Remote Protocol
    description: JSON/Protobuf-over-HTTP remote JDBC protocol for connecting clients to Calcite-based query servers.
- type: UseCases
  data:
  - name: Embedding SQL in Applications
    description: Add SQL querying capability to Java applications using the Calcite Java API without a full database.
  - name: Building Query Engines
    description: Use Calcite as the SQL parsing and optimization layer in custom query engine implementations.
  - name: Data Virtualization
    description: Federate queries across multiple heterogeneous data sources using Calcite adapters.
  - name: OLAP Query Optimization
    description: Accelerate analytical queries using materialized view rewriting and lattice-based summary tables.
  - name: SQL Dialect Translation
    description: Parse SQL in one dialect and transpile it to another using Calcite's SQL generation framework.
- type: Integrations
  data:
  - name: Apache Flink
    description: Flink uses Calcite for SQL parsing and query optimization in Flink SQL and Table API.
  - name: Apache Hive
    description: Hive uses Calcite for cost-based query optimization in HiveQL query planning.
  - name: Apache Druid
    description: Druid uses Calcite for SQL query parsing and planning against its time-series data store.
  - name: Apache Kafka
    description: ksqlDB and Kafka Streams use Calcite for SQL stream processing query planning.
  - name: Apache Beam
    description: Beam SQL uses Calcite for query planning on PCollection-based streaming and batch pipelines.
  - name: Elasticsearch
    description: Calcite provides a SQL adapter for querying Elasticsearch indices using standard SQL.
  - name: Apache Kylin
    description: Kylin uses Calcite as its SQL engine for OLAP cube query planning and execution.
maintainers:
- FN: Kin Lane
  email: info@apievangelist.com