apache/beam

Multiple batch joins on the same key results in multiple shuffles

Aperta

#19.097 aperta il 3 giu 2022

 (2 commenti) (0 reazioni) (1 assegnatario)Java (4097 fork)batch import
P3dslgood first issueimprovementsql

Metriche repository

Star
 (7313 stelle)
Metriche merge PR
 (Metriche PR in attesa)

Descrizione

The query like this:


SELECT a.*, b.*, c.* FROM a JOIN b ON a.some_id = b.some_id JOIN c ON a.some_id = c.some_id;

results in two shuffles. Can probably be optimized.

Relevant code:

Imported from Jira BEAM-5049. Original Jira may contain additional context. Reported by: kedin.

Guida contributor