Input
id |
---|
1001 |
1002 |
1003 |
1004 |
1005 |
1006 |
1007 |
1008 |
1009 |
1010 |
1011 |
1013 |
1014 |
1015 |
1016 |
1017 |
1018 |
1019 |
1020 |
... |
from_id | to_id |
---|---|
1057 | 1003 |
1076 | 1046 |
1080 | 1035 |
1110 | 1092 |
1129 | 1101 |
1134 | 1001 |
1134 | 1054 |
1152 | 4015 |
1155 | 1046 |
1160 | 1005 |
1161 | 1080 |
1161 | 1035 |
1172 | 4210 |
1178 | 1177 |
1195 | 1046 |
1196 | 1119 |
1204 | 1073 |
1209 | 1189 |
1222 | 3283 |
1225 | 1072 |
... | .... |
Call
Specifying the Seed value in the SQL-GR call guarantees that the result is repeatable on the same cluster. However, the result can differ between clusters, as the sample graph is not deterministic.
SELECT * FROM RandomWalkSample ( ON citvertices_2 AS Vertices PARTITION BY id ON citedges_2 AS Edges PARTITION BY from_id OUT TABLE VertexOutputTable (rw_vertices_15) OUT TABLE EdgeOutputTable (rw_edges_15) USING TargetKey ('to_id') FlyBackRate (0.15) SampleRate (0.15) Seed (1000) ) AS dt;
Output
name count ---------------- ----- vertices 1209 edges 744 sampled vertices 181 sampled edges 99
SELECT * FROM rw_vertices_15;
id_1 ---- 2047 2178 4204 2286 3006 1164 3272 2083 1225 3261 1287 3328 2270 2303 4124 2258 1059 1035 1304 1002 2038 1128 2073 1306 3258 2204 1188 1231 2147 4210 1126 4110 1322 4013 2219 3229 4102 1046 4160 3043 3050 2009 3228 1175 2301 4169 4104 3221 1262 1063 1268 1250 1083 1203 4209 3038 3046 2192 2197 2275 1122 1072 1088 2263 1027 3178 4106 3246 4239 2228 3251 2289 4083 2168 3250 2229 3312 3196 4243 1249 2065 2232 1161 3154 4107 1244 3059 1290 3163 1173 3125 3297 4094 2207 3256 3292 3291 2040 3027 2027 2262 3068 2184 1004 1309 4009 1166 1121 4045 2264 2271 4149 1101 1124 1292 2058 1200 3166 4044 2299 2149 1316 1193 2063 2248 1211 1302 1074 4222 1008 1264 4072 3055 3252 2011 1208 2076 3235 3034 2253 1080 3189 2290 2001 3310 1020 3307 2293 1137 4208 3090 2138 1191 4170 1192 3150 2260 3028 2026 2109 3184 2108 2004 3089 1028 1142 2298 1172 2002 1017 2064 3301 3212 4242 1034 1260 4085 3233 3045 3096 2300
SELECT * FROM rw_edges_15;
source_1 target_1 -------- -------- 4107 4110 2197 1292 2229 2009 2178 1166 4208 3184 4222 1101 2286 2262 3291 3292 3261 1192 3045 2004 2264 2147 3235 1260 2064 2063 1161 1080 2038 1290 1264 1101 4044 1268 4085 3184 3163 2064 3301 2293 3310 2260 1225 1072 2147 1124 1309 1203 3258 1188 4210 3154 3312 2001 2063 2064 1322 1304 4107 3212 4208 2149 3246 1002 2263 1083 4169 1002 3252 3068 2076 2004 2064 1101 1161 1035 4013 3261 4085 2149 3163 1101 3089 3328 2258 1002 1309 1121 4210 1172 2063 1101 3212 2064 4222 2293 4169 3154 3045 2076 3228 2232 2108 2064 3328 3089 1080 1035 4209 3028 2258 1080 2047 1008 4242 3292 4208 2064 4110 4107 2109 2073 4009 1287 3272 2253 4124 1002 3328 2229 3184 4208 2149 1264 3166 2197 4170 4110 3178 2258 3212 2149 4222 3250 2065 2204 1172 4210 3196 2192 2108 1124 3221 1175 3184 2108 2293 1101 4083 1128 4242 3291 3256 2147 2253 1175 2168 2064 4124 3246 3189 2264 2232 1002 2248 1306 2168 2063 2232 1172 4208 4085 2168 1101 4085 2108 3212 2108 4204 2063 3184 2064 4160 1208 1287 1046 3184 2149
Download a zip file of all examples and a SQL script file that creates their input tables.