Closeness Example 1: Unweighted, Unbounded Graph - Teradata Vantage

Input

Input tables are from AllPairsShortestPath Example 1: Unweighted, Unbounded Graph:

• vertices: callers
• edges: calls

SQL Call

SELECT * FROM Closeness (
  ON callers as vertices PARTITION BY callerid
  ON calls as edges PARTITION BY callerfrom
  USING
  TargetKey ('callerto')
  MaxDistance (-1)
  Accumulate ('callerid', 'callername')
) AS dt ORDER BY callerid;

Output

Because callerid 6 (Diana) has no outbound calls, the k-degree is 0.