Return Type - Analytics Database - Teradata Vantage

FNC_AMPInfo returns a pointer to an AMP_Info_t structure, defined as follows:

typedef struct {
  unsigned short NodeId;
  unsigned short AMPId;
  unsigned short LowestAMPOnNode;
} AMP_Info_t;

NodeId

Unique number of the node.

AMPId

Unique number of the AMP.

LowestAMPOnNode

Whether the current AMP is the lowest AMP on the same node as the invoking AMP: Zero if yes, nonzero if no.

If this function is invoked from a table operator that is associated with a map, then LowestAMPOnNode specifies whether the current AMP is the lowest AMP on the same node within the specified map.

A table function or operator that allows only the lowest AMP vproc to participate can use this field.