apache-calcite

Apache Calcite CSV Adapter - SQL Client

I am working on the development of a Connector interface with Elasticsearch (translate SQL to API DSL query syntax) .

I am starting with Apache Calcite CSV Adapter as a first step to test Calcite capabilities. I followed the tutorial https://calcite.apache.org/docs/tutorial.html 

My question is how to use the JDBC connector (and which configuration) in a SQL client like Dbeaver or Squirrel... ?

Thanks

Edit: This my configuration but it's not working enter image description here

enter image description here

Error: enter image description here

Solution

  • The DBeaver documentation describes how to add a new database driver. You can specify whatever parameters you need as well as provide a Calcite JAR file so the necessary code is available.

    The class name should be org.apache.calcite.jdbc.Driver. The URL Template will be something like jdbc:calcite:model=path/to/model.json where you specify a path to a model.json file which contains the necessary model to create the connection.