LocalClusteringCoefficient Example 2: WUN with DegreeRange 3 or Greater - Teradata Vantage

This example treats the input graph as a weighted, undirected network and outputs only nodes with degree range 3 or greater.

Input

Input tables are from LocalClusteringCoefficient Example 1: WUN:

• edges: trade
• vertices: country

SQL Call

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

Output