Is adding new column to vertica table expensive?
If I have large table with ex. 500milion rows, is adding new column with no value exspensive? Is there some description in documentation about this. Thanks, Josip
+1No. No value should be immediately
tested on 20TB, Vertica 7
tested on 20TB, Vertica 7
Thanks Daniel. Is there any summary of that test or something about that?
+1Hi!
Just say what I did and what I can confirm
Just say what I did and what I can confirm
Thanks one more time
Josip
Josip
+2Thanks Daniel for the real-world data.
We intend that this sort of operation should be fast. So, it's good to have someone else confirm that it actually is :-)
For what it's worth, as a column-store database, it is our design intention that column-level operations such as adding columns should always be cheap, whether you have 500 million rows, 500 billion rows, or even more than that.
Adam
We intend that this sort of operation should be fast. So, it's good to have someone else confirm that it actually is :-)
For what it's worth, as a column-store database, it is our design intention that column-level operations such as adding columns should always be cheap, whether you have 500 million rows, 500 billion rows, or even more than that.
Adam
Sign up
Already have an account? Login
Welcome to the Rocket Forum!
Please log in or register:
Employee Login | Registration Member Login | RegistrationEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.
77 4th Avenue
Waltham, MA 02451 USA
