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

Feature: Syntax support for direct COPY of tables to output format #5030

Open
ray6080 opened this issue Mar 11, 2025 · 0 comments
Open

Feature: Syntax support for direct COPY of tables to output format #5030

ray6080 opened this issue Mar 11, 2025 · 0 comments
Labels
feature New features or missing components of existing features

Comments

@ray6080
Copy link
Contributor

ray6080 commented Mar 11, 2025

API

Other

Description

We don't support directly specify copying a table to output formats. Instead, it has to go through COPYing a subquery.
An example is like this

CREATE NODE TABLE nodeTbl(id INT64 PRIMARY KEY, name STRING);
COPY (MATCH (t:nodeTbl) RETURN t.*) TO 'nodes.parquet';
CREATE REL TABLE relTbl(FROM nodeTbl TO nodeTbl, since DATE);
COPY (MATCH (:nodeTbl)-[e:relTbl]->(:nodeTbl) RETURN e.*) TO 'rels.parquet';

Simpler syntaxes are expected as following:

CREATE NODE TABLE nodeTbl(id INT64 PRIMARY KEY, name STRING);
COPY nodeTbl TO 'nodes.parquet';
CREATE REL TABLE relTbl(FROM nodeTbl TO nodeTbl, since DATE);
COPY relTbl TO 'rels.parquet';
@ray6080 ray6080 added the feature New features or missing components of existing features label Mar 11, 2025
@ray6080 ray6080 changed the title Feature: Syntax support for direct COPY of tables Feature: Syntax support for direct COPY of tables to output format Mar 11, 2025
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
feature New features or missing components of existing features
Projects
None yet
Development

No branches or pull requests

1 participant