Re: range columns including datetime column
Posted by:
Rob Voyer
Date: August 16, 2012 07:15AM
Thanks Mattias,
I changed the partition rules as follows:
PARTITION BY RANGE COLUMNS(period,start) (
PARTITION p123 VALUES LESS THAN (3, MAXVALUE),
PARTITION p4_1205 VALUES LESS THAN (4,'20120601000000'),
PARTITION p4_1206 VALUES LESS THAN (4,'20120701000000'),
PARTITION p4_1207 VALUES LESS THAN (4,'20120801000000'),
PARTITION p4_1208 VALUES LESS THAN (4,'20120901000000'),
PARTITION p4_1209 VALUES LESS THAN (4,'20121001000000'),
PARTITION p4_1210 VALUES LESS THAN (4,'20121101000000'),
PARTITION p4_1211 VALUES LESS THAN (4,'20121201000000'),
PARTITION p4_1212 VALUES LESS THAN (4,'20130101000000'),
PARTITION p5_1205 VALUES LESS THAN (5,'20120601000000'),
PARTITION p5_1206 VALUES LESS THAN (5,'20120701000000'),
PARTITION p5_1207 VALUES LESS THAN (5,'20120801000000'),
PARTITION p5_1208 VALUES LESS THAN (5,'20120901000000'),
PARTITION p5_1209 VALUES LESS THAN (5,'20121001000000'),
PARTITION p5_1210 VALUES LESS THAN (5,'20121101000000'),
PARTITION p5_1211 VALUES LESS THAN (5,'20121201000000'),
PARTITION p5_1212 VALUES LESS THAN (5,'20130101000000'),
PARTITION p6 VALUES LESS THAN (6,MAXVALUE)
This works but I have partitions for periods 4 and 5 when merging them together would have been better. But I can live with this.