Calcite
Table of Contents
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.
2 - Articles Related
Advertising
3 - Jdbc
jdbc:calcite:model=target/test-classes/model.json // or jdbc:calcite:schemaFactory=org.apache.calcite.adapter.druid.DruidSchemaFactory;schema.url=http://localhost:8082;schema.coordinatorUrl=http://localhost:8081
- 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" } } ] }
where:
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
VM:
Dataset:
Advertising
6 - Planner
- Eigenbase: the project where Calcite’s initial IP came from