7.00.02 - Input Table Aliases - Aster Analytics

Teradata Aster® Analytics Foundation User GuideUpdate 2

Aster Analytics
Release Number
September 2017
Content Type
Programming Reference
User Guide
Publication ID
English (United States)
Last Update

When function syntax specifies aliases for input tables, use them as specified; otherwise, an error occurs.

For example, in the following clauses of a graph function, "vertices" is the alias of the input table containing the vertices of the input graph and "edges" is the alias of the table containing the edges connecting the vertices:

  ON vertices_table AS vertices PARTITION BY ...
  ON edges_table AS edges PARTITION BY ...

Using different aliases, like the following, causes an error:

beehive=> ...
beehive=>   ON cities AS vr PARTITION BY ...
beehive=>   ON freeways AS edges PARTITION BY ...
beehive=> ...
ERROR: SQL-MR function ALLPAIRSSHORTESTPATH requires input table or query with alias: vertices