If I have a query:
T1
JOIN T2 ON T1.k1 = T2.k1
JOIN T3 ON T1.k2 = T2.k2
GROUP BY k2
Then even if T3 is tiny, we always seem to be doing partitioned join for k2. This is undesirable. Being able to broadcast should override reusing partitioning (maybe CBO?).
@mlyublena @feilong-liu
If I have a query:
T1
JOIN T2 ON T1.k1 = T2.k1
JOIN T3 ON T1.k2 = T2.k2
GROUP BY k2
Then even if T3 is tiny, we always seem to be doing partitioned join for k2. This is undesirable. Being able to broadcast should override reusing partitioning (maybe CBO?).
@mlyublena @feilong-liu