You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@calcite.apache.org by "Jiatao Tao (Jira)" <ji...@apache.org> on 2021/04/11 09:42:00 UTC

[jira] [Updated] (CALCITE-4578) skip SetOp#replaceInput when inputs are not changed

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

Jiatao Tao updated CALCITE-4578:
--------------------------------
    Description: 
Example like that: insert xxx VALUES (1, 'one'), (2, 'two'), (3, 'three')...(10000, 'ten thousand');

It generates a Union node with 10000 inputs, and the performance is poor, here's the profile:

!image-2021-04-11-16-53-35-466.png|width=740,height=185!

!image-2021-04-11-16-53-58-757.png|width=735,height=109!

> skip SetOp#replaceInput when inputs are not changed
> ---------------------------------------------------
>
>                 Key: CALCITE-4578
>                 URL: https://issues.apache.org/jira/browse/CALCITE-4578
>             Project: Calcite
>          Issue Type: Bug
>          Components: core
>            Reporter: Jiatao Tao
>            Assignee: Jiatao Tao
>            Priority: Major
>
> Example like that: insert xxx VALUES (1, 'one'), (2, 'two'), (3, 'three')...(10000, 'ten thousand');
> It generates a Union node with 10000 inputs, and the performance is poor, here's the profile:
> !image-2021-04-11-16-53-35-466.png|width=740,height=185!
> !image-2021-04-11-16-53-58-757.png|width=735,height=109!



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