16.20 - DecisionTreePredict Syntax - 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)
SELECT * FROM DecisionTreePredict (
  ON { table | view | (query) } AS AttributeTable
    PARTITION BY pid_col [,...] ORDER BY attribute
  ON { table | view | (query) } AS Model DIMENSION
  USING
  AttrTableGroupbyColumns ('gcol'[,...])
  AttrTablePIDColumns ('pid_col'[,...])
  AttrTableValColumn ('value_column')
  OutputResponseProbDist ({'true'|'t'|'yes'|'y'|'1'|'false'|'f'|'no'|'n'|'0'})
  Responses ('response'[,...])
  [ Accumulate ('accumulate_column'[,...])]
) AS alias;