citusdata / citusdata/citus_docs

Outer Join Reference Table with Distributed Table

Open
#799 1 comment 0 reactions 0 assignees View on GitHub
Dominant language
CSS
Stars
58
Forks
60
PR merge metrics
No merged PRs in 30d

Description

Based on the [documentation](http://docs.citusdata.com/en/v7.5/develop/reference_sql.html)
> Reference Tables can be used as “dimension” tables to join efficiently with large “fact” tables.

However, it turns out that we can't outer join reference table with large distributed table.

For example,I have a reference table `products` and a large distributed table `purchases`. The `purchases` table is distributed based on `customer_id` column.
Is there a plan for supporting outer join query between the reference and distributed table as follows?

```sql
select *
from products
left join purchases on products.id = purchases.product_id
where true
```

Thanks,

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.