1.1 - 8.10 - Where Functions Save Output Files - 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)

Model Files

Functions that output model files save them on the user schema on ML Engine.

If you run multiple instances of a function simultaneously, each run must use a unique name for each output file.

Nonmodel Output Files

By default, functions save nonmodel output files to the user database. To save an output table to a different database, prefix the table name with the database name; for example:

SELECT * FROM UnivariateStatistics (
  ON abc_table AS InputTable
  OUT TABLE MomentsTableName (db1.moments)
  OUT TABLE BasicTableName (db1.basic)
  OUT TABLE QuantilesTableName (db1.quantiles)
) AS dt;