Repository navigation
Databend into Apache Arrow through ADBC over the MySQL wire, using MySQL Connector/ODBC 9.4 (adbcBridge 0.1.0) #20407
Replies: 1 comment
|
A follow-up with one new measurement. On 2026-09-05 I ran the same seven-step ADBC workload (connect, SELECT 1, DDL + inserts + read, 1,000-row Native driver: connects, runs SELECT 1 and the eight-column DDL round trip, then stops at Table for all 28 PostgreSQL-wire and MySQL-wire databases, with each native driver's first error: https://adbcbridge.org/notes/native-adbc-drivers-on-wire-compatible-databases/ |
Uh oh!
There was an error while loading. Please reload this page.
adbcBridge is a small Apache-2.0 ADBC driver written in C11 that loads an ODBC driver and exposes it through the Arrow ADBC C ABI: block-cursor reads straight into Arrow record batches, bulk ingest, metadata, partitioned parallel reads. I ran Databend through it as one of 46 databases in a single compatibility workload and wanted to share the entry here, since the quirks it records are Databend-specific.
The
mysqlADBC driver may also work with Databend over its wire protocol; this entry is the route through MySQL Connector/ODBC and records exactly what it needed, so it is a second, documented route rather than a replacement.What was verified (Databend 1.2,
MySQL (via ODBC) 8.0.90-v1.2.881; driver: MySQL Connector/ODBC 9.4):SELECT 1 FROM DUAL WHERE @@sql_mode LIKE '%ansi_quotes%'(Unknown table "default"."default".DUAL) — identical through pyodbc, so it is the connector, not the bridgeNO_SSPS=1); through 8.4.0 the same entry failed only the non-BMP text check —héllo 🚀stored byte-exact, read back ashéllo ???on every read path including pyodbc, because 8.4.0 substitutes?for a non-BMP character before either C type sees itWhat the compatibility entry records: the server has no prepared statements, so the connector runs with
NO_SSPS=1; driver quirks handled:_binaryliterals for date/timestamp/binary params, MySQL type names in ingest DDL. Full entry: docs/COMPATIBILITY.md.Trying it (Python; Rust, Go, Java and C# are on the docs site):
Links: repository · docs · upstream notes · PyPI
It is a 0.1.0. If the entry says something wrong about Databend, or you run a version or driver I didn't, an issue on the repository with the details is the most useful thing you could send.
All reactions