Input Table Aliases - 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

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