Create the ExecR System Table Operator| Teradata VantageCore VMware - Creating the ExecR System Table Operator - Teradata VantageCore VMware

Teradata® VantageCore VMware - Base, Advanced, Enterprise Tiers Getting Started Guide

Deployment
VantageCore
Edition
VMware
Product
Teradata VantageCore VMware
Release Number
Deployer 4.0
Published
October 2023
ft:locale
en-US
ft:lastEdition
2023-10-31
dita:mapPath
gwx1617319441704.ditamap
dita:ditavalPath
nxb1617391283297.ditaval
dita:id
hrd1467245928404
Product Category
Cloud
The ExecR table operator is required and is used to execute R scripts.
  1. Run the 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
    Attempting to connect to CNS...Completed.
    Hello
    
    Input Supervisor Command:
    > start dip
    start dip
    
    Started 'dip' in window 1
    at Jul 23 15:29:02 2018
    
    Input Supervisor Command:
    > ^C
    #cnsterm 1
    Attempting to connect to CNS...Completed.
    Hello
    
    Type the password for user DBC or press the Enter key to quit:
    
    > dbc
    dbc
    
    ***Logon successfully completed.
    
    Select one of the following DIP SQL scripts to execute:
    (Press the Enter key to quit)
    
    44. DIPRTBLOP - R Table Operator
    
    >DIPRTBLOP
    DIPRTBLOP
    
    Executing DIPRTBLOP at Mon Jul 23 15:29:21 2018
    Please wait...
    
    DIPRTBLOP is complete at Mon Jul 23 15:29:26 2018
    Please review the results in /var/opt/teradata/tdtemp/dip44.txt on node 001-01
    
    Would you like to execute another DIP script (Y/N)?
    > N
    N
    
    Exiting DIP...