apache/beam

Multiple batch joins on the same key results in multiple shuffles

Open

#19.097 aberto em 3 de jun. de 2022

Ver no GitHub
 (0 comments) (0 reactions) (0 assignees)Java (4.097 forks)batch import
P3dslgood first issueimprovementsql

Métricas do repositório

Stars
 (7.313 stars)
Métricas de merge de PR
 (Mesclagem média 6d) (243 fundiu PRs em 30d)

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