11 Jun 18 · dan-irving · #teradata ·   Bookmark   ×

ERROR 2616 Numeric overflow during computation while doing count(*)

Scenario:

While trying to do a select count(*) from a table and I am not able to do it because of this error. I am not aware of the number of rows in the table.

Solution:

When your session runs in Teradata mode the result of a COUNT is INTEGER as you already noticed (in ANSI mode it will be a DECIMAL with at least 15 digits).

The workaround is simple, cast it to a bigint:

SELECT CAST(COUNT(*) AS BIGINT)...


dan-irving

posted on 11 Jun 18

Enjoy great content like this and a lot more !

Signup for a free account to write a post / comment / upvote posts. Its simple and takes less than 5 seconds

Copied