FYI, according to the Vertica SQL Reference Manual: Checking Column Constraints When you create a projection, Vertica checks column constraints during the process. For instance, if a join predicate includes a column with a FOREIGN_KEY constraint but without a NOT_NULL constraint, the CREATE PROJECT...

This can also be caused from having too many delete vectors in your projections. dbadmin=> select node_name, schema_name, projection_name, sum( deleted_row_count ) num_deleted_row_count, sum( used_bytes ) num_used_bytes from delete_vectors group by 1, 2, 3 order by 1, 2, 3; If the num_deleted_row_co...