7.00.02 - Input - Aster Analytics

Teradata Aster® Analytics Foundation User GuideUpdate 2

Product
Aster Analytics
Release Number
7.00.02
Release Date
September 2017
Content Type
Programming Reference
User Guide
Publication ID
B700-1022-700K
Language
English (United States)

The EigenvectorCentrality function has two required input tables, vertices and edges.

The vertices table defines the set of vertices in the graph. Each row represents a vertex. The following table describes the vertices table columns that the function uses. The table can have additional columns, but the function ignores them.

EigenvectorCentrality Vertices Table Schema
Column Name Data Type Description
vertex_key_column Any allowed in PARTITION BY clause Column that is, or is part of, the unique vertex key. Every column that is part of this key must appear in the PARTITION BY clause.
accumulate_column Any Column to be copied to the output table.

The edges table defines the set of edges in the graph. Each row represents an edge. the following table describes the schema of the edges table. The table can have additional columns, but the function ignores them.

EigenvectorCentrality Edges Table Schema
Column Name Data Type Description
source_vertex_key_column Any allowed in PARTITION BY clause Column that is, or is part of, the unique source vertex key. Every column that is part of this key must appear in the PARTITION BY clause.
target_vertex_key_column Same as data type of source_vertex_key_column Column that is, or is part of, the unique target vertex key.
edge_weight SMALLINT, INTEGER, or NUMERIC Column that contains the weights of the edges, which must be positive values. This column is required only for a weighted graph.
accumulate_column Any Column to be copied to the output table.