> Database

1 - About

Calcite is a Java SQL Processing engine where the data storage is developed in plugin.

Calcite is an open source cost based query optimizer and query execution framework.


3 - Jdbc

// or
  • A JSON model of a simple Calcite schema.
  "version": "1.0",
  "defaultSchema": "SALES",
  "schemas": [
      "name": "SALES",
      "type": "custom",
      "factory": "org.apache.calcite.adapter.csv.CsvSchemaFactory",
      "operand": {
        "directory": "sales"


Adapter can be built programmatically using the Schema SPI. see Calcite Schema SPI

4 - DDL

SELECT and DML are standardized, but DDL tends to be database-specific, so the calcite policy is that DDL extensions are made outside of Calcite. See CALCITE-609 for example.

You could copy work that has already been done in Drill and Phoenix in extending Calcite’s core parser for DDL.

5 - Test


6 - Planner

7 - Documentation / Reference

db/calcite.txt · Last modified: 2018/04/14 18:25 by gerardnico