Hello,
We are trying to quantile a large number of rows.
We have ran this code before and it ran fine.
The code is:
Select
Cust_ID
,quantile(100, Profit - ZeroIfNull(ABS(Acc_Amt))/12) as Perc
From
Customer_Table
We have tried removing the calculation, so we are quantiling a single value (e.g. just the Profit component), and we have tried the ANSI compliant syntax, but this fails too.
What seems to be happening is - at 1st the amps spool up nice and evenly, then the optimiser places EVERYTHING onto one AMP....
Is this 'normal' behaviour?
We are trying to quantile a large number of rows.
We have ran this code before and it ran fine.
The code is:
Select
Cust_ID
,quantile(100, Profit - ZeroIfNull(ABS(Acc_Amt))/12) as Perc
From
Customer_Table
We have tried removing the calculation, so we are quantiling a single value (e.g. just the Profit component), and we have tried the ANSI compliant syntax, but this fails too.
What seems to be happening is - at 1st the amps spool up nice and evenly, then the optimiser places EVERYTHING onto one AMP....
Is this 'normal' behaviour?