Hi, I would like to use Calcite as SQLPlanner in my open source project HerdDB https://github.com/diennea/herddb
HerdDB is a distributed database built in Java, it is essentially a distributed key-value store but is has an SQL layer which is the entrypoint for JDBC clients. Currently we have a very simple SQLPlanner, that is a component which maps SQL language to an internal AST which represents the access plan to data. I heard about Calcite and as far as I can see it would be easy to integrate Calcite as SQL Planner. I am expecting to have something like this: 1) Give to Calcite an SQL query + Current schema + available indexes.... 2) Calcite which creates a access plan using Calcite AST 3) Convert Calcite AST to HerdDB access plan AST I am not looking at something on the client-side I would like to use Calcite on the server is is possible ? Thank you in advance Enrico Olivelli [email protected]
