Where Functions Save Output Files - Teradata Vantage

Machine Learning Engine Analytic Function Reference

Product
Teradata Vantage
Release Number
8.10
1.1
Published
October 2019
Language
English (United States)
Last Update
2019-12-31
dita:mapPath
ima1540829771750.ditamap
dita:ditavalPath
jsj1481748799576.ditaval
dita:id
B700-4003
lifecycle
previous
Product Category
Teradata Vantageā„¢

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;