17.05 - NaiveBayesPredict Input - Teradata Database

Teradata Vantage™ - Advanced SQL Engine Analytic Functions

prodname
Advanced SQL Engine
Teradata Database
vrm_release
17.00
17.05
created_date
June 2020
category
Programming Reference
featnum
B035-1206-170K
Table Description
Input Contains test data. Has same schema as ML Engine Naive Bayes Classifier input table.
Model Model output by ML Engine Naive Bayes Classifier function.

Input Table Schema

See Teradata Vantage™ Machine Learning Engine Analytic Function Reference, B700-4003.

Model Schema

For CHARACTER and VARCHAR columns, CHARACTER SET must be either UNICODE or LATIN.

Double quotation marks around some column names are required because the names are either Advanced SQL Engine reserved keywords or are camel-case.

Column Data Type Description
"class" or class_nb VARCHAR Response.
"variable" or variable_nb VARCHAR Input variable (name of input column).
"type" or type_nb VARCHAR Input variable types ('NUMERIC' or 'CATEGORICAL').
category VARCHAR For categorical predictor, its level. For numeric predictor, NULL.
cnt INTEGER or BIGINT Count of observations with this class, variable, and category.
"sum" or sum_nb INTEGER or DOUBLE_PRECISION For numerical predictor, sum of variable values for observations with this class, variable, and category. For categorical predictor, NULL.
"sumSq" or sum_sq INTEGER or DOUBLE_PRECISION For numerical predictor, sum of square of variable values for observations with this class, variable, and category. For categorical predictor, NULL.
"totalCnt" or total_cnt INTEGER or BIGINT Total count of observations.