Common Analytic Functions in Teradata ML Engine and Teradata SQL Engine - Teradata Vantage

These analytic functions are available on both Teradata ML Engine and SQL Engine:

• Attribution
• Forest_Predict
• GLMPredict
• nPath
• NTree
• NaivebayesPredict
• NaiveBayesTextClassifierPredict
• Sessionize
• Single_Tree_Predict
• SparseSVMPredictor

They have common syntax and generate similar results. The analytic functions in SQL Engine are expected to run with better performance because they are native to the database.

A query that starts this way calls a SQL Engine analytic function:

SELECT * FROM function_name ( ...

A query that starts this way calls a Teradata ML Engine analytic function. You must append "@coprocessor" to the coprocessor function name specified in Teradata ML Engine Analytic Function Mapping:

SELECT * FROM function_name@coprocessor ( ...