RandomWalkSample Example - Teradata Vantage

Input

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