1.1 - Installing ML Engine Analytic Functions and Files - Teradata Vantage

Teradata Vantageā„¢ User Guide

Teradata Vantage
May 2020
User Guide

All ML Engine analytic functions come preinstalled and ready to use.

All analytic functions take input or output argument clauses. Argument clauses specify information the function needs to run, such as table or column names, algorithm parameters, or scalar values.

Some analytic functions have argument clauses that specify input or output files. These files typically contain models, dictionaries, or rules required (input) or produced by (output) the function. The default versions of the input files are preinstalled and ready to use.

Each Advanced SQL Engine user has a private schema in ML Engine for query or function execution. For example, if user alice references an ML Engine analytic function, she has a private schema named alice. By default, all ML Engine analytic functions and files are preinstalled in the public schema. ML Engine system functions (such as available_memory_on_jvm, qginitiatorexport, qginitiatorimport, and so on) are preinstalled in the nc_system schema. Whenever a user, such as alice, references an ML Engine function or file, the system follows a schema search path to try to find that function or file. For example, if alice runs a KMeans query, the system searches schema alice for a KMeans function, then searches schema public, then nc_system schema.

For a list of analytic functions that use files that are preinstalled on ML Engine and the files they use, see Teradata Vantageā„¢ Machine Learning Engine Analytic Function Reference, B700-4003.

The preinstalled versions of the analytic functions and input files are adequate for most needs. However, you might want to customize the behavior (change defaults) of functions to suit your particular needs. In most cases, you can change function behavior by changing its argument clauses.