When I thought i was going to increase some performance by increasing the buffer size in the IPC stage properties from 128 to 256, the second aggregator stage started aborting. The logged error message was ' Row out of sequence '. If this is about sort order, I had the data sorted when I select from the DB and had again set the same sort order in the aggregator inputs too. The two aggregators differ only by the grouping.
Somebody could point me what to understand from this, please.
ray.wurlod wrote:Is the first Aggregator stage doing anything you couldn't do with a GROUP BY clause in the SELECT statement?
The source OCI stage and the first aggregator together do a vertical pivot. I had used CASE expression to shift the column value and then sum the rows in the aggregator to pivot.