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

Posted to issues@impala.apache.org by "Tim Armstrong (Jira)" <ji...@apache.org> on 2020/12/21 17:47:00 UTC

[jira] [Resolved] (IMPALA-5727) Join Order Optimization time increases non-linearly with the number of tables

     [ https://issues.apache.org/jira/browse/IMPALA-5727?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Tim Armstrong resolved IMPALA-5727.
-----------------------------------
    Resolution: Later

Too open ended.

> Join Order Optimization time increases non-linearly with the number of tables
> -----------------------------------------------------------------------------
>
>                 Key: IMPALA-5727
>                 URL: https://issues.apache.org/jira/browse/IMPALA-5727
>             Project: IMPALA
>          Issue Type: Improvement
>          Components: Frontend
>            Reporter: Alan Choi
>            Priority: Major
>              Labels: performance, planner
>
> The planning time (believed to be in join order optimization) increases non-linearly with increasing number of tables in the join. By increasing the number of tables in the join from 5 to 10, the planning time increases from 200ms to 700+ms.
> For small data query, 700+ms planning time is significant.



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