You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "liu ming (JIRA)" <ji...@apache.org> on 2016/06/22 23:14:16 UTC
[jira] [Assigned] (TRAFODION-2010) UPDATE/DELETE cannot generate a
parallel plan properly
[ https://issues.apache.org/jira/browse/TRAFODION-2010?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
liu ming reassigned TRAFODION-2010:
-----------------------------------
Assignee: liu ming
> UPDATE/DELETE cannot generate a parallel plan properly
> ------------------------------------------------------
>
> Key: TRAFODION-2010
> URL: https://issues.apache.org/jira/browse/TRAFODION-2010
> Project: Apache Trafodion
> Issue Type: Bug
> Reporter: liu ming
> Assignee: liu ming
>
> For big UPDATE/DELETE, that is, affecting a lot of rows, for example, 10M rows to update, Trafodion cannot generate a proper parallel plan by default. So very slow.
> Reproduce steps:
> DDL
> CREATE TABLE T113B
> (
> UNIQ INT NO DEFAULT NOT NULL
> , C100K INT DEFAULT NULL
> , C10K INT DEFAULT NULL
> , C1K INT DEFAULT NULL
> , C100 INT DEFAULT NULL
> , C10 INT DEFAULT NULL
> , C1 INT DEFAULT NULL
> , C0 INT DEFAULT NULL ,
> Primary key(uniq)
> )
> SALT USING 80 PARTITIONS
> ATTRIBUTES ALIGNED FORMAT
> ;
>
> Populate data:
> upsert using load into t113b select
> 0 + (100000 * x100000) + (10000 * x10000) + (1000 * x1000) +
> (100 * x100) + (10 * x10) +( 1 * x1),
> 0 + (10000 * x10000) + (1000 * x1000) + (100 * x100) +
> (10 * x10) +( 1 * x1),
> 0 + (1000 * x1000) + (100 * x100) + (10 * x10) + (1 * x1),
> 0 + (100 * x100) + (10 * x10) + (1 * x1),
> 0 + (10 * x10) + (1 * x1),
> 0 + (1 * x1),
> 0,
> X0
> from (values(0)) t
> transpose 0,1,2,3,4,5,6,7,8,9 as x100000
> transpose 0,1,2,3,4,5,6,7,8,9 as x10000
> transpose 0,1,2,3,4,5,6,7,8,9 as x1000
> transpose 0,1,2,3,4,5,6,7,8,9 as x100
> transpose 0,1,2,3,4,5,6,7,8,9 as x10
> transpose 0,1,2,3,4,5,6,7,8,9 as x1
> transpose 0,1,2,3,4,5,6,7,8,9 as x0;
>
> The update DML
> explain options 'f' update t113b set c0 = 0 where c1 = 0;
> DELETE is similar.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)