design‑name

Name of the design for which you want to set the K-safety value, type VARCHAR.

k‑level

An integer between 0 and 2 that specifies the level of K-safety for the target design. This value must be compatible with the number of nodes in the database cluster:

• k‑level = 0: ≥ 1 nodes
• k‑level = 1: ≥ 3 nodes
• k‑level = 2: ≥ 5 nodes

If you omit this parameter, Vertica sets K‑safety for this design to 0 or 1, according to the number of nodes: 1 if the cluster contains ≥ 3 nodes, otherwise 0.

If you are a DBADMIN user and k‑level differs from system K‑safety, Vertica changes system K‑safety as follows:

• If k‑level is less than system K‑safety, Vertica changes system K‑safety to the lower level after the design is deployed.

• If k‑level is greater than system K‑safety and is valid for the database cluster, Vertica creates the required number of buddy projections for the tables in this design. If the design applies to all database tables, or all tables in the database have the required number of buddy projections, Database Designer changes system K‑safety to k‑level.

  If the design excludes some database tables and the number of their buddy projections is less than k‑level, Database Designer leaves system K‑safety unchanged. Instead, it returns a warning and indicates which tables need new buddy projections in order to adjust system K‑safety.

If you are a DBDUSER, Vertica ignores this parameter.