Do Aggregators(Both master & Child) also contain partitions(Shards) similar to leaves and do they also perform query execution tasks(DML) along with leaves in addtion to aggregating results from leaves?
Only leaves contain partitions. For the most part all DML execution will run on the leaves, however, some operations will run on the aggregators at the optimizer’s discretion.
You could also take a look at Cluster Components · SingleStore Documentation if you want to read more.