Define a Vertica Flattened Table Column as Having Both DEFAULT and SET USING Constraints
Jim Knicely, Vertica Field Chief Technologist
January 31, 2020
Columns in a flattened table can query other tables with constraints DEFAULT and SET USING . Vertica executes DEFAULT queries only on new rows when they are added to the flattened table, through load operations such as INSERT and COPY. Thereafter, changes in the original data sources have no effect on the flattened table. Vertica...