16.20 - Installation of R Components and Packages - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL External Routine Programming

Advanced SQL Engine
Teradata Database
Release Number
Release Date
April 2020
Content Type
Programming Reference
Publication ID
English (United States)
Due to the complexity of installation, length of time and need for a database restart, Teradata strongly recommends enlisting Teradata Customer Services to install the R Components and Packages. Please contact your Teradata representative to order this service.

In Vantage systems, R can be used to execute R scripts through the SCRIPT table operator or the ExecR table operator.

To use R with the SCRIPT table operator, your system administrator must install the R interpreter. For details about SCRIPT, see the Table Operators section in Teradata Vantage™ - SQL Operators and User-Defined Functions, B035-1210.

To use R with the ExecR table operator, your system administrator must install the following components:
  • The R interpreter
  • The Fortran compiler
  • The udfGPL library
Furthermore, the DIP script DipRTblOp must be executed to create the ExecR table operator. The rest of the present section has more information about the R interpreter and Fortran packages. For more information about installing the udfGPL library and creating the ExecR table operator, see Procedure to Enable R Functionality with ExecR.

Together with the R interpreter, R add-on packages can be used to apply a variety of statistical techniques to analyze data stored in the Advanced SQL Engine. Once installed, a new package (pkg) can be used within an R script by including the following statement: library(pkg).

In Vantage systems,
  • The R interpreter is provided through the teradata-R package
  • Selected R add-on packages are available through the teradata-R-addons package (for a listing of the add-on titles that are bundled in a given release, see the README file of that release)
  • The Fortran compiler comprises of the packages:
    • gcc-fortran, gcc43-fortran, libgfortran43 (in SLES 11 Service Pack 3 systems)
    • gcc-fortran, gcc48-fortran, libgfortran3 (in SLES 12 Service Pack 3 systems)
The teradata-R interpreter is a prerequisite for the teradata-R-addons package. See R and Python Support in Teradata Vantage for R and Python support in-database in Vantage.