-NA- - R and Python Support in Teradata Vantageā„¢ - Teradata Vantage

prodname
Teradata Python Package
Teradata R Package
Teradata Vantage
vrm_release
-NA-
created_date
April 2020
category
Fast Facts
featnum
FF-0002

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.

Client Side

The Teradata R and Python packages 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 R Package tdplyr (R library package)

Installation: See Teradata R Package User Guide

The tdplyr package conforms and works with the verbs and functions of the dplyr and dbplyr libraries.

Functions: See Teradata R Package Function Reference

Teradata Python Package teradataml (Python library package)

Installation: See Teradata Python Package User Guide

The teradataml package uses SQLAlchemy and works with verbs and functions of Pandas library.

Functions: See Teradata Python Package Function Reference

In-Database

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 SQL External Routine Programming for information on Script Table Operator and ExecR Table Operator usage.

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.