lance-format/lance

[DuckDB] Support export table from DuckDB to lance

Open

#654 ouverte le 4 mars 2023

Voir sur GitHub
 (0 commentaires) (0 réactions) (0 assignés)Rust (695 forks)github user discovery
duckdbenhancementhelp wantedrust

Métriques du dépôt

Stars
 (6 582 stars)
Métriques de merge PR
 (Merge moyen 6j 1h) (219 PRs mergées en 30 j)

Description

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);

Guide contributeur