citusdata / citusdata/pg_shard

Make zero-shard SELECT consistent with CitusDB

Open
#134 0 comments 0 reactions 0 assignees View on GitHub
citus integration
Dominant language
C
Stars
1.1k
Forks
62
PR merge metrics
No merged PRs in 30d

Description

Making a query against a table that has been marked as "distributed" (either by `CREATE TABLE ... DISTRIBUTE BY ...` or using `master_create_distributed_table`) which does not yet have any shards (created using either `\stage` or `master_create_worker_shards`) results in different behavior depending upon whether the active planner is CitusDB's or `pg_shard`'s:
- Under CitusDB, the query returns zero rows
- `pg_shard` raises an error directing the user to call `master_create_worker_shards`

The latter is obviously helpful under `pg_shard` (especially for users who have missed this step), but is confusing under CitusDB. Now that integration is tighter, we need to figure out what the best approach is.

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.