apache/beam

Multiple batch joins on the same key results in multiple shuffles

Aberta

#19.097 aberto em 3 de jun. de 2022

 (2 comentários) (0 reação) (1 responsável)Java (4.097 forks)batch import
P3dslgood first issueimprovementsql

Métricas do repositório

Stars
 (7.313 estrelas)
Métricas de merge de PR
 (Métricas PR pendentes)

Description

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.

Guia do colaborador