Installation of R Components and Packages | Teradata Vantage - 17.10 - Installation of R Components and Packages - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - SQL External Routine Programming

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1147-171K
Language
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.