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

Teradata® R Package User Guide

Product
Teradata R Package
Release Number
16.20
Published
February 2020
Language
English (United States)
Last Update
2022-05-02
dita:mapPath
qbt1519078127352.ditamap
dita:ditavalPath
Generic_no_ie_no_tempfilter.ditaval

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.