citusdata / citusdata/citus

Evaluate wider SQL support by fetching data to one node

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

Description

For SQL queries that Citus currently doesn't parallelize (for example, repartitioned subselects with large table joins), we could pull all related data to a single node and run the query on that node.

This way, if Citus can't parallelize a query, we'd still run the query instead of erroring out on it. The drawback is that these queries would go much slower than ones that get parallelized.

Contributor guide

Open the contributing guide

Research direction

No files, tests, or entry points are named in the issue. First clarify how unsupported SQL queries should be detected and how related data would be fetched to one node; done would mean such queries execute instead of erroring, with the slower behavior understood and tested.

Written by the indexing model from the issue text.

Assessment

Tech stack
c, postgresql, sql
Domain
backend, databases, distributed-systems
Issue type
Feature
Difficulty
5/5
Estimated time
Over a week
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
25/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.