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 LocalClusteringCoefficient function has two required input tables, vertices and edges.

The following table describes the vertices table columns that you must or can specify in the function call. The table can have additional columns, but the function ignores them.

LocalClusteringCoefficient VerticesTable Schema
Column Name Data Type Description
vertex_key_column INTEGER Column that is, or is part of, the vertex key. Every column in the key appears in this table.

If the table has duplicate vertices, the function uses the first one and ignores the others.

accumulate_column Any [Optional] Column to be copied to the output table.

The following table describes the edges table columns that you must or can specify in the function call. The table can have additional columns, but the function ignores them.

The data-checking rules for the edges table are, given nodes A and B:

  • No graph can have multiple A→B edges.
  • An undirected graph cannot have edges A→B and B→A.
LocalClusteringCoefficient Edges Table Schema
Column Name Data Type Description
source_vertex_key_column INTEGER Column that is, or is part of, the key of the source vertex. Every column in the key appears in this table.
target_vertex_key_column INTEGER Column that is, or is part of, the key of the target vertex. Every column in the key appears in this table.
edge_weight DOUBLE PRECISION Column that contains the edge weights. The function uses only positive edge weights. The sum of the edge weights that the function uses must be 1.