1.1 - 8.10 - Modularity Example: Unweighted Edges - Teradata Vantage

Teradata Vantage™ - Machine Learning Engine Analytic Function Reference

Product
Teradata Vantage
Release Number
1.1
8.10
Release Date
October 2019
Content Type
Programming Reference
Publication ID
B700-4003-079K
Language
English (United States)
This example specifies CommunityEdgeTable, which Teradata recommends only when necessary, because creating this table can greatly increase function run time.

Followers follow leaders with equal intensity (all edges have default weight 1).

SQL Call

SELECT * FROM Modularity (
  ON friends AS Vertices PARTITION BY friends_name
  ON followers_leaders AS Edges PARTITION BY follower
  USING
  TargetKey ('leader')
  CommunityAssociation ('group_id')
  Accumulate ('friends_name','location')
) AS dt ORDER BY friends_name;

Output

 friends_name location      resolution community_id num_communities modularity_score    
 ------------ ------------- ---------- ------------ --------------- ------------------- 
 alex         san francisco        1.0 los angeles                3 0.42592594027519226
 bob          los angeles          1.0 los angeles                3 0.42592594027519226
 casey        los angeles          1.0 los angeles                3 0.42592594027519226
 danny        new york city        1.0 austin                     3 0.42592594027519226
 eve          birmingham           1.0 austin                     3 0.42592594027519226
 fox          austin               1.0 austin                     3 0.42592594027519226
 gohar        miami                1.0 chicago                    3 0.42592594027519226
 harry        chicago              1.0 chicago                    3 0.42592594027519226

Download a zip file of all examples and a SQL script file that creates their input tables from the attachment in the left sidebar.