Executing the Job

select * from agg_result;

This figure present only a part of the table. You can find that the selected input columns are aggregated and written into the agg_result table and the partition column is filled with the value prospective.