ApproximateCloseness Example | Teradata Vantage - ApproximateCloseness Example - Teradata Vantage

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.