This example specifies CommunityEdgeTable, which Teradata recommends only when necessary, because creating this table can greatly increase function run time.
Input
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.