7.00.02 - Output - 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 output table has a row for each source vertex. The reachable target vertices exclude the source vertex itself; that is, the function does not calculate the closeness and k-degree scores for loops.

Closeness Output Table Schema
Column Data Type Description
inv_sum_dist DOUBLE PRECISION Inverse of the sum of the shortest distances to all reachable target vertices. If there are no reachable target vertices, then this value is NULL.
inv_avg_dist DOUBLE PRECISION Inverse of the average shortest distances to all reachable target vertices. If there are no reachable target vertices, then this value is NULL.
sum_inv_dist DOUBLE PRECISION Sum of the inverse distances to all reachable target vertices. If there are no reachable target vertices, then this value is NULL.
kdegree DOUBLE PRECISION Total number of reachable target vertices. If there are no reachable target vertices, then this value is 0.
accumulate_column Same as in vertex table Column copied from the vertex table. The table can have more than one such column. These columns enable you to identify different closeness scores.