Error Calling tdplyr Functions When Connected to Vantage with NewSQL Engine Only - 17.00 - Error Calling tdplyr Functions When Connected to Vantage with Advanced SQL Engine Only - Teradata R Package

Teradata® R Package User Guide

prodname
Teradata R Package
vrm_release
17.00
created_date
November 2020
category
User Guide
featnum
B700-4005-090K

If you connect to Vantage without a ML Engine installed and request to run tdplyr analytic functions that execute on ML Engine, the system will return an error.

For example:

If you call the function td_glm_mle() on Vantage without a ML Engine, then the following error occurs:

Error: [tdplyr - (TDR_E3100)] Function td_glm_mle failed.
In value[[3L]](cond):
[tdplyr - (TDR_E1001)] Error in new_result(connection@ptr, statement): nanodbc/nanodbc.cpp:1344: 42000: [Teradata][ODBC Teradata Driver][Teradata Database](-3707)Syntax error, expected something like ')' between the word 'GLM' and '('.

The Teradata R package is fully featured when connected to Vantage with Advanced SQL Engine and ML Engine. When connecting to a Vantage with Advanced SQL Engine only, the only analytic functions available to the tdplyr users are the ones that execute on the Advanced SQL Engine. To invoke and use tdplyr analytic functions available on the ML Engine, your Vantage system must consists of Advanced SQL Engine and ML Engine.