search

apache / iceberg

Apache Iceberg
https://iceberg.apache.org/
Apache License 2.0
6.36k stars 2.2k forks source link

Support different JDBC backend in the `JdbcCatalog` #9733

Open jbonofre opened 8 months ago

jbonofre commented 8 months ago

Feature Request / Improvement

Currently the JdbcCatalog doesn't work with all JDBC backend. For instance, if it works fine with SQLite and PostgreSQL, we have a syntax error while using with MySQL while using ESCAPE.

I will implement JdbcAdapter approach as I did in Apache ActiveMQ JDBC storage.

I'm working on the PR about that.

Query engine

None

jbonofre commented 7 months ago

in Apache Karaf and Pax JDBC, I experimented to use jdbi (https://jdbi.org/) to abstract the different JDBC backend. I'm testing this approach for the Iceberg JdbcCatalog.

jbonofre commented 4 months ago

I'm resuming the branch here.