Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[DuckDB] Support export table from DuckDB to lance #654

Open
eddyxu opened this issue Mar 4, 2023 · 0 comments
Open

[DuckDB] Support export table from DuckDB to lance #654

eddyxu opened this issue Mar 4, 2023 · 0 comments
Labels
duckdb enhancement New feature or request help wanted Extra attention is needed rust Rust related tasks

Comments

@eddyxu
Copy link
Contributor

eddyxu commented Mar 4, 2023

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);
@eddyxu eddyxu added enhancement New feature or request help wanted Extra attention is needed duckdb rust Rust related tasks labels Mar 4, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
duckdb enhancement New feature or request help wanted Extra attention is needed rust Rust related tasks
Projects
None yet
Development

No branches or pull requests

1 participant