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

Support COPY TO statement #1692

Closed
rfdavid opened this issue Jun 19, 2023 · 0 comments
Closed

Support COPY TO statement #1692

rfdavid opened this issue Jun 19, 2023 · 0 comments
Assignees

Comments

@rfdavid
Copy link
Collaborator

rfdavid commented Jun 19, 2023

Proposal

This feature will enable users to export query results to either CSV or PARQUET files using our current COPY command. In the same way, we already perform COPY FROM, the idea is to use the same statement using COPY TO, similar to DuckDB Copy.

Examples

Add HEADER and DELIMITER properties
COPY Person TO "person.csv" (HEADER=true, DELIM='|');

Write a specific query result to result.parquet
COPY (MATCH (a:person) RETURN a.name) TO "result.parquet"

TODO

The idea is to break down the deliverable of the complete feature in the following order:

  1. Implement COPY ([query]) TO "file.csv"
  2. Support .parquet file type
  3. Optimize via parallel processing
@rfdavid rfdavid self-assigned this Jun 19, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants