liu ming created TRAFODION-2010: ----------------------------------- Summary: 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
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)