Input
Input tables are from AllPairsShortestPath Example: Unweighted, Unbounded Graph:
- Vertices: callers
- Edges: calls
SQL Call
SELECT * FROM ApproximateCloseness ( ON callers AS Vertices ON calls AS Edges OUT TABLE OutputTable (ApproximateCloseness_out_1) USING VertexKey ('callerid') TargetKey ('callerto') MaxDistance (5) SourceKey ('callerfrom') StopThreshold (0.1) ) AS dt;
Output
message --------------------------------------------------------------------------- Successful! The final result is successfully stored in the table specified in OutputTab
src closeness kdegree ----------- ---------------------- ----------- 1 2.50000000000000E-001 4 3 1.00000000000000E 000 1 4 1.00000000000000E 000 1 6 ? 0 2 5.00000000000000E-001 2 5 1.00000000000000E 000 1
Download a zip file of all examples and a SQL script file that creates their input tables.