Creating the ExecR System Table Operator - Teradata Database on VMware

Teradata Database on VMware Base, Advanced, Enterprise Tiers Getting Started Guide

Product
Teradata Database on VMware
Release Number
03.00.00
Published
January 2018
Language
English (United States)
Last Update
2018-04-25
dita:mapPath
ofk1516814149566.ditamap
dita:ditavalPath
TDVMWare_phase4a-4b_BAE.ditaval.ditaval
dita:id
B035-5958
lifecycle
previous
Product Category
Cloud
The ExecR table operator is required and is used to execute R scripts.
  1. Run the optional DipRTblOp DIP script to create the ExecR table operator. Following is an example of how to run the DipRTblOp script from a Teradata node:
    #cnsterm 6
    Input Supervisor Command:
    > start dip
    Started 'dip' in window 1
    Input Supervisor Command:
    > ^C -- <control C>
    #cnsterm 1
    Attempting to connect to CNS...Completed
    Type the password for user DBC or press the Enter key to quit:
    > xxx
    ***Logon successfully completed.
    Select one of the following DIP SQL scripts to execute:
    (Press the Enter key to quit)
    ...
    40. DIPRTBLOP - R Table Operator
    > 40
    Executing DIPRTBLOP
    Please wait...
    DIPRTBLOP is complete
    Please review the results in /var/opt/teradata/tdtemp/dip40.txt on node 1-1
    Would you like to execute another DIP script (Y/N)?
    > N
    Exiting DIP...