Error Calling teradataml Analytic Functions | Teradata Package for Python - Error Calling teradataml Analytic Functions - Teradata Package for Python

Teradata® Package for Python User Guide

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Teradata Package for Python
Release Number
20.00
Published
March 2024
Language
English (United States)
Last Update
2024-04-09
dita:mapPath
nvi1706202040305.ditamap
dita:ditavalPath
plt1683835213376.ditaval
dita:id
rkb1531260709148
Product Category
Teradata Vantage

When Connected to Teradata Vantage with Analytics Database Only

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

For example:
TeradataMlException: [Teradata][teradataml](TDML_2102) Failed to execute SQL:
teradatasql.OperationalError: [Version 16.20.0.32] [Session 76702] [Teradata Database] [Error 3707] 
Syntax error, expected something like ')' between the word 'ConfusionMatrix' and '('.")'

The Teradata Package for Python is fully featured when connected to Vantage with Analytics Database and ML Engine.

When connecting to Vantage with Analytics Database only, the only analytic functions available to the teradataml users are the ones that execute on the Analytics Database.

To invoke and use teradataml analytic functions available on the ML Engine, your Vantage system must consist of both Analytics Database and ML Engine.

Using Function with New Arguments on Vantage1.0

Following functions are updated by adding new arguments.

Analytic Functions Newly added arguments

(Only supported on Vantage 1.1 or later)

AdaBoost categorical_encoding
DecisionForest categorical_encoding
DecisionTree categorical_encoding
KNN 'accumulate' and 'output_prob'
RandomSample setid_as_first_column
VarMax 'order_p', 'order_d', 'order_q', 'seasonal_order_p', 'seasonal_order_d', 'seasonal_order_q'
These arguments are supported only on Vantage 1.1 or later. If used with Vantage 1.0, the following error will show:
[Teradata Database] [Error 4382] Argument {argument-name} is not defined in the function mapping definition

Using Sampling Function on Vantage1.0

Using Sampling function on Vantage 1.0 will result in following error. This function is now only supported on Vantage1.1 or later.
[Teradata Database] [Error 4381] Only one ON clause with either undefined or empty correlation name can be mapped to ANY in function mapping definition.