R and Python Support in Teradata Vantage
Teradata Vantage supports R and Python languages both at client side and in database.
The client side and in-database options for R and Python enable users to jointly perform analytics with no SQL coding required, provide users with functions for data manipulation and transformation, data filtering and sub-setting, and can be used in conjunction with open source libraries.
The Teradata packages for R and Python include access to powerful Vantage analytic functions together with data manipulation functions to provide extensive analytic capabilities at client side. They combine the benefits of the open source language environment with the massive parallel processing capabilities of Vantage, which includes Machine Learning Engine analytic functions and Advanced SQL Engine in-database analytic functions.
The language interpreters are installed on a client machine that connects to Vantage.
|Teradata Package for R||tdplyr (R library package)
Installation: See Teradata® Package for R User Guide
|The tdplyr package conforms and works with the verbs and functions of the dplyr and dbplyr libraries.
Functions: See Teradata® Package for R Function Reference
|Teradata Package for Python||teradataml (Python library package)
Installation: See Teradata® Package for Python User Guide
|The teradataml package uses SQLAlchemy and works with verbs and functions of Pandas library.
Functions: See Teradata® Package for Python Function Reference
The Teradata distribution packages for in-database R and Python script execution offer updated and self-contained versions of the R and Python interpreters for in-database language execution, and collections of select popular add-on libraries.
The language interpreters and corresponding R and Python add-on libraries are installed on each Advanced SQL Engine node.
See Teradata Vantage™ - SQL Operators and User-Defined Functions and Teradata Vantage™ - External SQL Routine Programming for information on Script Table Operator and ExecR Table Operator usage.
See Orange Book: R and Python Analytics with SCRIPT Table Operator and the accompanying code samples at https://github.com/Teradata/r-python-sto-orangebook-scripts for in-depth information. You must log in to see the Orange Books.
|R Interpreter and Add-ons Packages Bundle||Supports native, in-database execution of R scripts on the SQL Engine TPA nodes using the SCRIPT and ExecR Table Operators.
Installation: Contact your Teradata account representative to order R Installation Service.
|R Interpreter Package: Includes R interpreter together with dependent system libraries to enable native in-node R execution on Vantage using the SCRIPT Table Operator (STO) or the ExecR Table Operator (ExecR TO).
R Add-ons Package: Offers select R add-on library packages to extend R usability in native in-node R execution on Vantage using the STO or the ExecR TO.
|Python Interpreter and Add-ons Packages Bundle||Supports native, in-database execution of Python scripts on the SQL Engine TPA nodes using the SCRIPT Table Operators.
Installation: Contact your Teradata account representative to order Python Installation Service.
|Python Interpreter Package: Includes the Python interpreter together with dependent system libraries to enable native in-node Python execution on Vantage using the SCRIPT Table Operator (STO).
Python Add-ons Package: Offers select Python add-on library packages to extend Python usability in native in-node Python execution on Vantage using the STO.