Closeness Syntax Elements - Teradata Vantage

Machine Learning Engine Analytic Function Reference

Product
Teradata Vantage
Release Number
9.02
9.01
2.0
1.3
Published
February 2022
Language
English (United States)
Last Update
2022-02-10
dita:mapPath
rnn1580259159235.ditamap
dita:ditavalPath
ybt1582220416951.ditaval
dita:id
B700-4003
lifecycle
previous
Product Category
Teradata Vantageā„¢
TargetKey
Specify the target key (the names of the Edges table columns that identify the target vertex). If you specify targets_table, then the function uses only the Vertices in targets_table as targets (which must be a subset of those that this syntax element specifies).
Directed
[Optional] Specify whether the graph is directed.
Default: 'true'
EdgeWeight
[Optional] Specify the name of the Edges table column that contains edge weights. The weights are positive values.
Default behavior: The weight of each edge is 1 (that is, the graph is unweighted).
MaxDistance
[Optional] Specify the maximum distance (an integer) between the source and target Vertices. A negative max_distance specifies an infinite distance. If Vertices are separated by more than max_distance, the function does not output them.
Default: 10
GroupSize
[Optional] Specify the number of source Vertices that run a SNSP algorithm in parallel. If group_size exceeds the number of source Vertices in each partition, s, then s is the group size. Running a group of Vertices on each vworker, in parallel, uses less memory than running all Vertices on each vworker.
Default behavior: The function calculates the optimal group size based on cluster and query characteristics.
SampleRate
[Optional] Specify the sample rate (the percentage of source Vertices to sample), a numeric value in the range (0, 1].
Default: 1
Accumulate
[Optional] Specify the names of the Vertices table columns to copy to the output table. These columns enable you to identify the different closeness scores in the output table.