Some functions have both ML Engine and Advanced SQL Engine versions, which have different syntax.
If a function has both versions, a query that starts this way calls the Advanced SQL Engine version:
SELECT * FROM function_name ( ...
To call the ML Engine version instead of the Advanced SQL Engine version, append "_MLE" to the function name:
SELECT * FROM function_name_MLE ( ...
To call ML Engine functions nPath and NTree, use nPath@coprocessor and NTree@coprocessor. To call Advanced SQL Engine function nPath, use nPath.
More Information
| Information | Document |
|---|---|
|
Teradata Vantage™ User Guide, B700-4002 |
|
Teradata Vantage™ - Advanced SQL Engine Analytic Functions, B035-1206 |