Numeric overflow occurred during computation teradata ошибка

You use wrong datatypes, a DECIMAL(18,15) means 18 digits, 15 of them fractional, so the maximum value is 999.999999999999999.

And when you multiply two decimals, the number of fractional digits adds up, NEW_CALC results in 38 fractional digits. Do a TYPE(cast(UNITS as DECIMAL(18,18))* cast(PRICE as DECIMAL(18,18))).

This will work:

cast(UNITS as DECIMAL(38,15))* PRICE

But you better change the column’s datatype to something like (18,2) or (18,4), I don’t think anyone uses more than 4 digits for prices.

answered May 13, 2015 at 17:06

pandas.io.sql.DatabaseError: Execution failed on sql 'SELECT count(*) AS "count", count("id") AS "count__id",
 ......
FROM {td_schema}.{td_table}
SAMPLE 10000': [Version 17.0.0.8] [Session 31075829] [Teradata Database] [Error 2616] Numeric overflow occurred during computation

To summarize the issue which is occurring: Teradata implicitly casts any COUNT to INT. Running a normal count could be written more verbosely as
SELECT CAST(COUNT(*) AS INT) AS "count" ...

The overflow does not occur during the count, but rather during the cast which implicitly happens. There are Teradata configs which could override this behavior on a per installation basis (in TD15.10 there’s a new dbscontrol flag to change the default to BIGINT or NUMBER).

We should likely automatically CAST all Teradata COUNT operations to BIGINT or NUMBER to avoid the error

This is now possible with the --cast-to-bigint flag and via YAML. This will cast any int32 columns to int64 before running an aggregation. Closed with PR #461