Excerpt:
Check it out here: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.
https://community.dev.hpe.com/t5/Vertic ... a-p/237990