You can specify a table column's default value using a DEFAULT expression. To see how, check out this quick tip.
When you set a default value, Vertica evaluates the DEFAULT expression and sets the column on load operations, if the operation omits a value for the column.
In addition, that DEFAULT expression can be derived from another column in the same table!