Select purchase_date, sum(amt)
group by purchase_date
select partition_name p_name, sum(amt) total
group by partition_name
given mytable has 3 partitions named, p1, p2 and p3
the result should look like this:
Thank you for your consideration.