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