Input - Aster Analytics

Teradata Aster Analytics Foundation User Guide

Product
Aster Analytics
Release Number
6.21
Published
November 2016
Language
English (United States)
Last Update
2018-04-14
dita:mapPath
kiu1466024880662.ditamap
dita:ditavalPath
AA-notempfilter_pdf_output.ditaval
dita:id
B700-1021
lifecycle
previous
Product Category
Software

The PageRank function requires two input tables, vertices and edges.

The vertices table must contain the unique identifier (vertex key attributes) of each vertex. The unique identifier of a vertex can consist of multiple columns. The vertices table can also have columns that are not vertex key attributes. If these additional columns are specified by the Accumulate argument, the function copies them to the output table; otherwise, it ignores them.

PageRank Vertices Table
Column Name Data Type Description
vertex_key_attribute VARCHAR Contains a vertex key attribute. The vertices table must have at least one such column, and can have more than one. The vertex key attribute columns comprise the vertex_key on which the vertices table must be partitioned.
accumulate_column Any Column to be copied to the output table. The vertices table can have zero or more such columns.

The edges table must contain columns for the source and target vertices of each edge.

PageRank Edges Table
Column Name Data Type Description
edge_source INTEGER Contains the numbers of the source nodes of the edges. The edges table must be partitioned on this column.
edge_target INTEGER Contains the numbers of the target nodes of the edges.