lance-format/lance

[DuckDB] Support export table from DuckDB to lance

Open

#654 aperta il 4 mar 2023

Vedi su GitHub
 (0 commenti) (0 reazioni) (0 assegnatari)Rust (695 fork)github user discovery
duckdbenhancementhelp wantedrust

Metriche repository

Star
 (6582 star)
Metriche merge PR
 (Merge medio 6g 1h) (219 PR mergiate in 30 g)

Descrizione

Problem Statement

Duckdb allows to export a table via COPY/EXPORT command.

https://duckdb.org/docs/sql/statements/export.html

-- export the table contents with the given options
EXPORT DATABASE 'target_directory' (FORMAT CSV, DELIMITER '|');
-- export the table contents as parquet
EXPORT DATABASE 'target_directory' (FORMAT PARQUET);

Desired Behavior

In Lance duckdb extension, we could support COPY statement

COPY (SELECT * FROM tbl) TO 'output.lance' (FORMAT LANCE);

Guida contributor