NaiveBayesPredict Input - Teradata® Database

Database Analytic Functions

Product
Teradata® Database
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2021-07-28
dita:mapPath
Teradata_Vantage™___Advanced_SQL_Engine_Analytic_Functions.withLogo_upload_July2021/wnd1589838592459.ditamap
dita:ditavalPath
Teradata_Vantage™___Advanced_SQL_Engine_Analytic_Functions.withLogo_upload_July2021/ayr1485454803741.ditaval
dita:id
B035-1206
lifecycle
previous
Product Category
Teradata Vantage™
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.