Analytic Function Output Tables | Teradata Vantage - Output Tables - Teradata Vantage

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.