LocalClusteringCoefficient Input - Teradata Vantage

Machine Learning Engine Analytic Function Reference

Product
Teradata Vantage
Release Number
8.10
1.1
Published
October 2019
Language
English (United States)
Last Update
2019-12-31
dita:mapPath
ima1540829771750.ditamap
dita:ditavalPath
jsj1481748799576.ditaval
dita:id
B700-4003
lifecycle
previous
Product Category
Teradata Vantage™

Vertices Schema

Each row represents a vertex of the graph. If the table has duplicate vertices, the function uses the first one and ignores its duplicates. The table can have additional columns, but the function ignores them.

Column Data Type Description
vertex_key_column INTEGER [Column appears once for each specified vertex_key_column.] All or part of unique vertex key. Cannot be NULL.
accumulate_column Any [Column appears once for each specified accumulate_column.] Column to copy to output table.

Edges Schema

Each row represents an edge of the graph. 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.
Column Data Type Description
source_vertex_key_column INTEGER Column appears once for each specified source_vertex_key_column.] All or part of key that identifies source vertex of edge. Must be a vertex_key_column in Vertices table. Cannot be NULL.
target_vertex_key_column INTEGER Column appears once for each specified target_vertex_key_column.] All or part of key that identifies target vertex of edge. Must be a vertex_key_column in Vertices table. Cannot be NULL.
edge_weight DOUBLE PRECISION [Required only for weighted graph.] Edge weight. Function uses only positive edge weights. Sum of edge weights that function uses must be 1.