partition and subpartitioning help
i tried to create partition with year as main partition and month has subpartition
but the value are not going to the correct partitioned rows
so i created a other partition only with range (to_days(timestamp))
when i insert it the value goes to the correct partition .
but when use select statement like(select * from data where timestamp>='2009-09-01' and timesatmp<='2009-09-02') it gives the result
but when use this statement(select * from data where timestamp>='2009-09-01' and timesatmp<='2009-09-31') is show a error like Glib-Error **:gmem c:173:faildata allocate 8224000000 byte aborting
the create table id is like this
PARTITION p_2003_02 VALUES LESS THAN (to_days('2003-03-01')),
PARTITION p_2003_03 VALUES LESS THAN (to_days('2003-04-01')),
PARTITION p_2003_04 VALUES LESS THAN (to_days('2003-05-01')),
PARTITION p_2003_05 VALUES LESS THAN (to_days('2003-06-01')),
PARTITION p_2003_06 VALUES LESS THAN (to_days('2003-07-01')),
PARTITION p_2003_07 VALUES LESS THAN (to_days('2003-08-01')),
PARTITION p_2003_08 VALUES LESS THAN (to_days('2003-09-01')),
PARTITION p_2003_09 VALUES LESS THAN (to_days('2003-10-01')),
PARTITION p_2003_10 VALUES LESS THAN (to_days('2003-11-01')),
PARTITION p_2003_11 VALUES LESS THAN (to_days('2003-12-01')),
PARTITION p_2003_12 VALUES LESS THAN (to_days('2004-01-01')),
PARTITION p_2004_01 VALUES LESS THAN (to_days('2004-02-01')),
PARTITION p_2004_02 VALUES LESS THAN (to_days('2004-03-01')),
PARTITION p_2004_03 VALUES LESS THAN (to_days('2004-04-01')),
PARTITION p_2004_04 VALUES LESS THAN (to_days('2004-05-01')),
PARTITION p_2004_05 VALUES LESS THAN (to_days('2004-06-01')),
PARTITION p_2004_06 VALUES LESS THAN (to_days('2004-07-01')),
PARTITION p_2004_07 VALUES LESS THAN (to_days('2004-08-01')),
PARTITION p_2004_08 VALUES LESS THAN (to_days('2004-09-01')),
PARTITION p_2004_09 VALUES LESS THAN (to_days('2004-10-01')),
PARTITION p_2004_10 VALUES LESS THAN (to_days('2004-11-01')),
PARTITION p_2004_11 VALUES LESS THAN (to_days('2004-12-01')),
PARTITION p_2004_12 VALUES LESS THAN (to_days('2005-01-01')),
PARTITION p_2005_01 VALUES LESS THAN (to_days('2005-02-01')),
PARTITION p_2005_02 VALUES LESS THAN (to_days('2005-03-01')),
PARTITION p_2005_03 VALUES LESS THAN (to_days('2005-04-01')),
PARTITION p_2005_04 VALUES LESS THAN (to_days('2005-05-01')),
PARTITION p_2005_05 VALUES LESS THAN (to_days('2005-06-01')),
PARTITION p_2005_06 VALUES LESS THAN (to_days('2005-07-01')),
PARTITION p_2005_07 VALUES LESS THAN (to_days('2005-08-01')),
PARTITION p_2005_08 VALUES LESS THAN (to_days('2005-09-01')),
PARTITION p_2005_09 VALUES LESS THAN (to_days('2005-10-01')),
PARTITION p_2005_10 VALUES LESS THAN (to_days('2005-11-01')),
PARTITION p_2005_11 VALUES LESS THAN (to_days('2005-12-01')),
PARTITION p_2005_12 VALUES LESS THAN (to_days('2006-01-01')),
..
..
..
..
PARTITION p11 VALUES LESS THAN MAXVALUE);
what to do give me suggestion
soon