You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@kylin.apache.org by "Zhichao Zhang (Jira)" <ji...@apache.org> on 2020/09/18 01:03:00 UTC

[jira] [Created] (KYLIN-4762) Optimize join where there is the same shardby partition num on join key

Zhichao  Zhang created KYLIN-4762:
-------------------------------------

             Summary: Optimize join where there is the same shardby partition num on join key
                 Key: KYLIN-4762
                 URL: https://issues.apache.org/jira/browse/KYLIN-4762
             Project: Kylin
          Issue Type: Improvement
          Components: Query Engine
    Affects Versions: v4.0.0-beta
            Reporter: Zhichao  Zhang
            Assignee: Zhichao  Zhang
         Attachments: shardby_join.png

Optimize join by reducing shuffle when there is the same shard by partition number on join key.

When execute this sql, the execution plan is shown below:

!shardby_join.png!



--
This message was sent by Atlassian Jira
(v8.3.4#803005)