
复制drop table t1; CREATE TABLE t1 ( l_orderkey INTEGER NOT NULL,区索 l_partkey INTEGER, l_suppkey INTEGER, l_shipdate date, padding1 char(30) ) PARTITION BY RANGE(l_shipdate) ( STARTING 2008-01-01 ENDING 2008-12-31 EVERY 1 MONTH ) ; INSERT INTO t1 (l_orderkey, l_partkey, l_suppkey,l_shipdate,padding1) WITH TEMP (COUNTER, l_orderkey, l_partkey, l_suppkey,l_shipdate,padding1) AS ( VALUES (0, MOD(INT(RAND() * 12000000), 25), MOD(INT(RAND() * 12000000), 30), MOD(INT(RAND() * 12000000), 30), DATE(MOD(INT(RAND() * 12000000), 366)+733042), A) UNION ALL SELECT (COUNTER + 1), MOD(INT(RAND() * 12000000), 25), MOD(INT(RAND() * 12000000), 30), MOD(INT(RAND() * 12000000), 30), DATE(MOD(INT(RAND() * 12000000), 366)+733042), A FROM TEMP WHERE (COUNTER + 1) <12000000 ) SELECT l_orderkey, l_partkey, l_suppkey,l_shipdate,padding1 FROM TEMP ; 1.2.3.4.5.6.7.8.9.10.11.12.13.14.15.16.17.18.19.20.21.22.