DSXchange

ray.wurlod wrote:Welcome aboard. What execution mode are you using for the Aggregator stage? What aggregation mode (sort or hash) are you using? ...

Execution mode is parralel. Aggregation mode is sort.

I forgot to mention that there is no warnings in the job log.

In my job I have to sum data in 120 columns grouping by 10 other columns. Total number of rows to aggregate is about 5-6 millions. All rows are sorted and partitioned in sort stage before aggregation. But aggregation performance still very low on Aggregator stage - only 2000-3000 rows/sec :( I tried...