citusdata / citusdata/citus

Support direct shard COPY

Open
#4,943 3 comments 0 reactions 0 assignees View on GitHub
enhancement
Dominant language
C
Stars
12.8k
Forks
794
Avg merge
2d 14h
Merged PRs (30d)
31

Description

The process utility hook gives us some liberty to deal with non-existent names in utility commands such as COPY.

That means we could support commands that copy directly to/from shards via the coordinator, e.g.:
```sql
COPY data_102008 FROM STDIN;
COPY data_102008 TO STDOUT;
```

If the table does not exist, the coordinator could check whether it matches a shard name and redirect the COPY to the shard.

This would be helpful for migrations to and from Citus.

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.