Packaging Apache Calcite CSV example into a JDBC driver

Question

The CSV example at https://calcite.apache.org/docs/tutorial.html shows how to access the CSV data using sqlline.

Does anyone know of any tutorial that show how to create a standalone JDBC driver from scratch for CSV example, so that it can be use for example using squirrelsql?

How did you configure the JDBC for squirrelsql? – O. Sam Feb 02 '22 at 21:40 — O. Sam, Feb 02 '22 at 21:40

score 0 · Accepted Answer · answered May 10 '20 at 18:22

0

You shouldn't need to repackage anything as the standard artifacts contain a JDBC driver. You can see examples of valid JDBC connection strings in the documentation.

For the CSV adapter, you might have a connection string like the following (substituting the appropriate path).

jdbc:calcite:schemaFactory=org.apache.calcite.adapter.csv.CsvSchemaFactory; schema.directory=/path/to/csv/files

answered May 10 '20 at 18:22

Michael Mior

28,107
9
89
113

How can I use it in a SQL client like Dbeaver? – O. Sam Feb 02 '22 at 21:39
1

@O.Sam That is a separate question and you should ask a new question. – Michael Mior Feb 03 '22 at 16:09
i create an other tread https://stackoverflow.com/questions/71227079/apache-calcite-csv-adapter-sql-client can you please check it – O. Sam Feb 22 '22 at 19:17

Packaging Apache Calcite CSV example into a JDBC driver

1 Answers1