[314]: numeric overflow ?

[Former Member]

Hi,

I try to understand ...

I want to aggregate some values, but i've got this error message :

[314]: numeric overflow: search table error:  [6944] AttributeEngine: overflow in numeric calculation;JEAggregate pop1(setIndex('TEST:F_EXPORT','en'),setAttribute('MT_VALEUR'),setAggregationTypes(1))

SQL is :

SQL
select cd_pays,sum(mt_valeur) from f_export group by cd_pays

I work with AWS

max() returns values..

[Former Member · Accepted solution]

Hi Stéphane,

You might have hit the upper limit of the datatype on column "mt_valeur" and the AttributeEngine gives you the numeric overflow error message.

You may need to alter the table column datatype to higher (for example from REAL to DOUBLE), or you can try another workaround with datatype conversion function (for example TO_DOUBLE) before the aggregation function:

select

cd_pays,sum(TO_DOUBLE(mt_valeur))

from

f_export

group

by cd_pays

Regards,

Ferry