RxInTeradata: Generate Teradata In-Database Compute Context

Article
07/12/2022

Description

DEPRECATED: Creates a compute context for running RevoScaleR analyses inside a Teradata database.

Usage

  RxInTeradata(object, remoteShareDir = "/tmp", connectionString = "", shareDir = "/tmp", 
     revoPath = NULL, controlDB = "revoAnalytics_Zqht2", wait = TRUE, consoleOutput = FALSE, autoCleanup = TRUE, 
     packagesToLoad = NULL,   ...  )

Arguments

`object`

An optional RxInTeradata object.

`remoteShareDir`

The share directory in Teradata.

`connectionString`

An ODBC connection string used to connect to the Teradata database.

`shareDir`

The share directory. This directory must exist on the client with write permission.

`revoPath`

The path where Microsoft R Server is installed on Teradata.

`controlDB`

The control database name a user can specify for supporting user isolation to enhance security. This requires that stored procedures, stored functions and tables are properly created and initialized in the control database, and access permissions are granted to users.

`wait`

logical value. If TRUE, the job will be blocking and will not return until it has completed or has failed. If FALSE, the job will be non-blocking and return immediately, allowing you to continue running other R code. The object rxgLastPendingJob is created with the job information. The client connection with Teradata must be maintained while the job is running, even in non-blocking mode.

`consoleOutput`

logical scalar.If TRUE, causes the standard output of the R processes on the AMPS to be printed to the user console. This value may be overwritten by passing a non-NULL logical value to the consoleOutput argument provided in rxExec and rxGetJobResults.

`autoCleanup`

logical scalar. If TRUE, the default behavior is to clean up the temporary computational artifacts and delete the result objects upon retrieval. If FALSE, then the computational results are not deleted, and the results may be acquired using rxGetJobResults, and the output via rxGetJobOutput until the rxCleanupJobs is used to delete the results and other artifacts. Leaving this flag set to FALSE can result in accumulation of compute artifacts which you may eventually need to delete before they fill up your hard drive.

`packagesToLoad`

NOT YET IMPLEMENTED. Optional character vector specifying additional packages to be loaded on the nodes when jobs are run in this compute context.

`...`

additional arguments to be passed to the underlying function. Two useful additional arguments are traceEnabled=TRUE and traceLevel=7, which taken together enable run-time tracing of your in-Teradata computations. traceEnabled and traceLevel are deprecated as of MRS 9.0.2 and will be removed from this Compute Context in the next major release. Please use rxOptions(traceLevel=7) to enable run-time tracing in-Teradata

Examples


 ## Not run:

baseTD <- RxInTeradata(
   connectionString = "DSN=TeradataVM64",
   shareDir = "C:/AllShare/myName",
   remoteShareDir = "/tmp/revoJobs",
   revoPath = "/usr/lib64/RRO-8.0.3/R-3.1.3/lib64/R",
   consoleOutput = TRUE,
   wait = TRUE,
   autoCleanup = TRUE)
  ## End(Not run)

Partager via