RE:how to make partititon for my table as required

[venkat puvvada]

dear all,
i done like this..
step1:
create table pvk_table_test_solve1 as SELECT * from pvk_table_test;

step2:
ALTER table pvk_table_test_solve1 add PRIMARY KEY(asset_id, reading_datetime, meter_id);

step3:
ALTER TABLE pvk_table_test_solve1 PARTITION BY HASH(month(reading_date) )
PARTITIONS 12;
error:
[SQL] ALTER TABLE pvk_table_test_solve1 PARTITION BY HASH(month(reading_date) )
PARTITIONS 12;
[Err] 1503 - A PRIMARY KEY must include all columns in the table's partitioning function


my requirement :
SELECT reading_date ,..... FROM pvk_table_test_slove1 eu
WHERE reading_date >='2009-10-02' AND reading_date <= '2010-10-02' AND assetid ='99' GROUP BY reading_date,eu.tou;

note:
because of not using partition filed in my query we are not getting good result.
now,what i need to do for this case?


please help me on the same....

regards,
venkat p



Edited 3 time(s). Last edit at 04/13/2011 01:21AM by venkat puvvada.