Disabling Numeric Overflow

Moderator: NorbertKrupa

Post Reply
User avatar
JimKnicely
Site Admin
Site Admin
Posts: 1825
Joined: Sat Jan 21, 2012 4:58 am
Contact:

Disabling Numeric Overflow

Post by JimKnicely » Thu Nov 17, 2016 8:38 pm

Great new post "Disabling Numeric Overflow" on the Vertica Blog site...

Excerpt:
Prior to version 8.0, using a column that has a numeric data type with the functions SUM, SUM_FLOAT, or AVG could result in numeric overflow. When using SUM, SUM_FLOAT, or AVG functions with a numeric data type, Vertica would silently overflow if the result exceeded the precision you set when defining the numeric column.

Now, you have the ability to turn-off numeric overflow and add implicit precision to your numeric data types.
As of 8.0, you have two options:
  • Use the default overflow handling. You won’t experience performance impact, but may encounter numeric overflow.
  • Turn off silent numeric overflow and specify an extra precision value to handle larger results correctly. If the specified precision is exceeded, Vertica provides an error message. This option has a modest performance impact.
Check it out here:
https://community.dev.hpe.com/t5/Vertic ... a-p/237990
Jim Knicely

Image

Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.

Post Reply

Return to “Vertica Links”