apecloud / myduckserver

MySQL & Postgres Analytics, Reimagined
184 stars 8 forks source link

feat: translate LOAD DATA for DuckDB #100

Closed fanyang01 closed 1 month ago

fanyang01 commented 1 month ago

This PR implements the fast path proposed in #69.

fanyang01 commented 1 month ago

Note that DuckDB's behavior can be different from MySQL if the data contains special characters: https://github.com/duckdb/duckdb/issues/14434

Let's use DuckDB aggressively for now and find a way to resolve the above issue in the future.