1.1 - 8.10 - Output Tables - Teradata Vantage

Teradata Vantage™ - Machine Learning Engine Analytic Function Reference

Product
Teradata Vantage
Release Number
1.1
8.10
Release Date
October 2019
Content Type
Programming Reference
Publication ID
B700-4003-079K
Language
English (United States)

Primary Output Table

The primary output table of a function does not appear in an OUT TABLE clause in the function syntax. The function displays the primary output table to the screen, but does not save it. To save the primary output table, create a table from the function call. For example:

CREATE MULTISET TABLE fft_output1 AS (
  SELECT * FROM FFT (
  ON fft_input AS InputTable PARTITION BY id1 ORDER BY timestep
  USING
  TargetColumns ('value1')
  ) AS dt
) WITH DATA;

Secondary Output Tables

Secondary output tables, if any, appear in OUT TABLE clauses in the function syntax. Each OUT TABLE clause specifies a table name, to which the function saves the secondary output table. If the table name includes a schema, the function saves the file in that schema; otherwise, it saves the file in the current schema.