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)
