LocalClusteringCoefficient Example 1: WUN - Teradata Vantage

This example treats the input graph as a weighted, undirected network (WUN).

Input

In the following figure, nodes represent countries, edges connect countries that trade with each other, and numbers on edges represent trade propensity.

The graph in the figure is represented by the vertices and edges tables country and trade, respectively.

SQL Call

SELECT * FROM LocalClusteringCoefficient (
  ON trade as edges PARTITION BY fromid
  ON country as vertices PARTITION BY countryid
  USING
  TargetKey ('toid')
  EdgeWeight ('tradeweight') 
  Directed ('f') 
  Accumulate ('countryid', 'name')
) AS dt ORDER BY countryid;

Output