Teradata Vantage is our flagship data platform for enterprise analytics. Advanced SQL Engine is the best-in-class processing engine at the Vantage core. Advanced SQL refers to the ability to run advanced analytic functions beyond that of standard SQL.
This document provides detailed description and complete usage information for all the functions and verbs in the Teradata® Package for R, tdplyr.
tdplyr Function Categories
Categories of tdplyr package functions:
- td_<name>_<engine>: Analytic functions.
- td_<name>_context: API functions that manage the connection and certain internal data structures called context.
- <name>.Teradata: R S3 functions that override the corresponding dplyr package functions with new functionality. In most cases, tdplyr-specific additional parameters are added to these functions.
- td_<name>_predict_<engine> and predict.td_<name>_<engine>: Scoring and prediction functions that are invoked with the predict S3 generic call or with a corresponding "td_*_predict" function call.
- <name>.ScriptTableOperator: An overridden S3 function "name" to perform functions related to Script Table Operator (STO).
- print.<class_name>: R S3 function is overridden to print object of specific class "class_name”"
Note: name is part of a function name that indicates the specific task of the function. engine is the location where the function is executed. Valid values are mle for Machine Learning Engine and sqle for SQL Engine.
tdplyr Analytic Function Default Execution Locations
Each analytic function in tdplyr has an equivalent function that can be invoked without engine suffix.
For the tdplyr analytic functions without engine suffix, the following table lists those that have the default execution location in the Advanced SQL Engine.
|Function Name||Executed in||Equivalent to|
All other tdplyr analytic functions without engine suffix are executed by default in the Machine Learning Engine, and are equivalent to the td_<name>_mle functions in tdplyr.
Note: Teradata recommends using tdplyr analytic functions with engine suffix.
The Moving Average analytic function does not have an equivalent function that can be invoked without an engine suffix. Invoke on the SQL Engine using td_moving_average_sqle with the argument 'mavgtype'.