Basic hash-partitioning of the stock table in HammerDB

stock_partitioned.sql

BEGIN;
CREATE TABLE stock_partitioned (LIKE stock INCLUDING ALL) PARTITION BY HASH (s_w_id);
CREATE TABLE stock_00 PARTITION OF stock_partitioned FOR VALUES WITH (MODULUS 10, REMAINDER 0);                                                                                   
CREATE TABLE stock_01 PARTITION OF stock_partitioned FOR VALUES WITH (MODULUS 10, REMAINDER 1);                                                                                   
CREATE TABLE stock_02 PARTITION OF stock_partitioned FOR VALUES WITH (MODULUS 10, REMAINDER 2);                                                                                   
CREATE TABLE stock_03 PARTITION OF stock_partitioned FOR VALUES WITH (MODULUS 10, REMAINDER 3);                                                                                   
CREATE TABLE stock_04 PARTITION OF stock_partitioned FOR VALUES WITH (MODULUS 10, REMAINDER 4);                                                                                   
CREATE TABLE stock_05 PARTITION OF stock_partitioned FOR VALUES WITH (MODULUS 10, REMAINDER 5);                                                                                   
CREATE TABLE stock_06 PARTITION OF stock_partitioned FOR VALUES WITH (MODULUS 10, REMAINDER 6);                                                                                   
CREATE TABLE stock_07 PARTITION OF stock_partitioned FOR VALUES WITH (MODULUS 10, REMAINDER 7);                                                                                   
CREATE TABLE stock_08 PARTITION OF stock_partitioned FOR VALUES WITH (MODULUS 10, REMAINDER 8);                                                                                   
CREATE TABLE stock_09 PARTITION OF stock_partitioned FOR VALUES WITH (MODULUS 10, REMAINDER 9);                                                                                   
INSERT INTO stock_partitioned SELECT * FROM stock;
ALTER TABLE stock RENAME TO stock_regular;
ALTER TABLE stock_partitioned RENAME TO stock;
COMMIT;