ML Engine analytic functions run on ML Engine, accessing data that resides on Advanced SQL Engine.
To run an ML Engine analytic function, submit a SQL query that references one or more ML Engine functions. The function execution is specified in the FROM clause as a table expression. The exact syntax is specified in ML Engine Analytic Function Execution SQL Syntax.
These steps performed during function execution:
- All required data is transferred from Advanced SQL Engine to ML Engine using Teradata QueryGrid™.
- The ML Engine analytic function is run on ML Engine.
- Results are returned to Advanced SQL Engine.
For some analytic functions, additional secondary output tables are also returned to Advanced SQL Engine.
- All intermediate data used in executing ML Engine analytic function is removed from ML Engine.