Vertica Analytics Platform Version 10.1.x Documentation
Setting Node Type
When you create a node, Vertica automatically sets its type to
PERMANENT. This enables Vertica to use this node to store data. You can change a node's type with
ALTER NODE, to one of the following:
- PERMANENT: (default): A node that stores data.
- EPHEMERAL: A node that is in transition from one type to another—typically, from PERMANENT to either STANDBY or EXECUTE.
- STANDBY: A node that is reserved to replace any node when it goes down. A standby node stores no segments or data until it is called to replace a down node. When used as a replacement node, Vertica changes its type to PERMANENT. For more information, see Active Standby Nodes.
- EXECUTE: A node that is reserved for computation purposes only. An execute node contains no segments or data.
STANDBY and EXECUTE node types are supported only in Enterprise Mode.
Was this topic helpful?