Vertica v8.0 - changing data type int to decimal(39,0) in a production table with 4 billion records
Hi Vertica Experts,
I have a scenario that I need to change the datatype of a column from integer to decimal(39,0) in a production table but I am struggling to find an efficient way how to do it.
The table is in production and has 4 billion records.
I've tried the following in a development environment:
The standard alter table doesn't work:
ALTER TABLE SCHEMA.TableName alter column ColumnName set data type decimal(39,0);
Changing the data type from int to decimal(18,0) works fine but extending from decimal(18,0) to decimal(39,0) doesn't work.
Converting int to varchar doesn't work.
Any help is welcome.