1.1 - ML Engine Analytic Function Execution - Teradata Vantage

Teradata Vantage™ User Guide

prodname
Teradata Vantage
vrm_release
1.1
created_date
May 2020
category
User Guide
featnum
B700-4002-079K

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:
  1. All required data is transferred from Advanced SQL Engine to ML Engine using Teradata QueryGrid™.
  2. The ML Engine analytic function is run on ML Engine.
  3. Results are returned to Advanced SQL Engine.

    For some analytic functions, additional secondary output tables are also returned to Advanced SQL Engine.

  4. All intermediate data used in executing ML Engine analytic function is removed from ML Engine.