Vertica Analytics Platform Version 9.2.x Documentation

NODES

Lists details about the nodes in the database.

Column Name Data Type Description
NODE_NAME

VARCHAR(128)

The name of the node.

NODE_ID

INTEGER

Catalog-assigned integer value that uniquely identifies the node.

NODE_STATE

VARCHAR(128)

The node's current state, one of the following:

  • UP
  • DOWN
  • READY
  • UNSAFE
  • SHUTDOWN
  • SHUTDOWN ERROR
  • RECOVERING
  • RECOVERY ERROR
  • RECOVERED
  • INITIALIZING
  • STAND BY
  • NEEDS CATCH UP
NODE_ADDRESS

VARCHAR(80)

The host address of the node.

NODE_ADDRESS_FAMILY
VARCHAR(10) The IP Version of the node_address. For example, ipv4.
EXPORT_ADDRESS

VARCHAR(8192)

The IP address of the node (on the public network) used for import/export operations and native load-balancing.

EXPORT_ADDRESS_FAMILY
VARCHAR(10) The IP Version of the export_address. For example, ipv4.
CATALOG_PATH

VARCHAR(8192)

The absolute path to the catalog on the node.

NODE_TYPE
VARCHAR(9) The type of the node. For more information on the types of nodes, refer to Setting Node Type.
IS_EPHEMERAL

BOOLEAN

(Deprecated) True if this node has been marked as ephemeral. (in preparation for removing it from the cluster).

STANDING_IN_FOR
VARCHAR(128) The name of the node that this node is currently replacing.
LAST_MSG_FROM_NODE_AT
TIMESTAMPZ The date and time the last message was received from this node.
NODE_DOWN_SINCE
TIMESTAMPZ The amount of time that the replaced node has been unavailable.