Outer Join Reference Table with Distributed Table

[alhassan-fadel]

Based on the documentation

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?

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

Thanks,

[homam86]

Issue moved to citusdata/citus #2531 via ZenHub