Agg: When checking operator: User inserted sort "Agg.ToAgg_Sort" does not fulfill the sort requirements of the downstream operator "APT_SortedGroup2Operator in Agg"
But when i unchecked the Perform Sort in the Aggregator it worked
You can use a SORT stage before the AGGR stage to sort the data and the partitioning must be on the same fields as the grouping keys in the AGGR stage.
ray.wurlod wrote:Hash table aggregation method is recommended for 1000 or fewer distinct grouping values per MB. Looks like you've exceeded this limit.
How can we know how much MB our aggregator stage is using. If we know that we can count of record length and chosse between hash or sort.
please reply
ray.wurlod wrote:Hash table aggregation method is recommended for 1000 or fewer distinct grouping values per MB. Looks like you've exceeded this limit.
How can we know how much MB our aggregator stage is using. If we know that we can count of record length and chosse between hash or sort.
please reply