Page 2 of 2
Re: Change table column's data type
Posted: Fri May 04, 2012 8:45 pm
by JimKnicely
Here is a great post by a even greater guy that discusses this topic a little more ...
http://proplabs.org/2012/05/04/vertica- ... le-column/
Re: Change table column's data type
Posted: Sat May 05, 2012 10:00 am
by id10t
Hi, Jim.
I'm afraid is not the end
![Smile :-)](./images/smilies/icon_e_smile.gif)
.
You didn't investigate a case with prejoin-projections
![Wink ;-)](./images/smilies/icon_e_wink.gif)
Its a long story and bad idea (imho) modify column data type on production system (there are may be segments, buddy/prejoin-projections).
Re: Change table column's data type
Posted: Tue Jun 05, 2012 1:39 pm
by JimKnicely
Great news, Vertica 6.0 gives us the ability to change a table column's data type...
Here's an excerpt from the New Feature's Guide:
Using new parameters in the ALTER TABLE statement, you can now perform the following operations:
- Change, reorganize, and remove tble partitions
Add table columns with a default derived expression
Drop table columns
Change a column's data type
Rename a table or sequence owner
Re: Change table column's data type
Posted: Tue Jun 05, 2012 1:48 pm
by rajasekhart
Wow .. Really a very good news..
Thank you jim.