How to alter a column data type from numeric(3,2) to numeric(5,4) in Vertica
In Vertica, you can alter the precision, but you cannot alter the scale of the numeric:
Here are two options:
1- Create a new table with new column data type, load it with the data from exiting table, drop the old one and rename the new one.
2- Create a new column in the table, load the column with the data, drop the old column and rename the new one.