But if i use
select count(pk1)
,partition_name
from bb_bb60_stats.aa
partition (AA_2012_06 )
group by pk1
having count (pk1) > 1;
~
I will get 19.6 million rows . This is the partition where all the duplicates got in.