16.20 - NaiveBayesPredict Input - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ - NewSQL Engine Analytic Functions

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Release Date
July 2019
Content Type
Programming Reference
Publication ID
B035-1206-162K
Language
English (United States)
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 Teradata Database 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.