For Regression
TD_XGBoostPredict( ON { table | view | (query) } AS InputTable [ PARTITION BY ANY ] ON { table | view | (query) } AS ModelTable DIMENSION USING IDColumn ({'id_column' | id_column_range }) [ NumParallelTrees (num_trees) ] [ NumBoostRounds (iterations) ] [ ModelType ('regression') ] [ Accumulate ({ 'accumulate_column' | accumulate_column_range }[,...]) ] )
For Classification
TD_XGBoostPredict( ON { table | view | (query) } AS InputTable [ PARTITION BY ANY ] ON { table | view | (query) } AS ModelTable DIMENSION USING IDColumn ({'id_column' | id_column_range }) [ NumParallelTrees (num_trees) ] [ NumBoostRounds (iterations) ] [ ModelType ('classification') ] [ OutputProb ({'true'|'t'|'yes'|'y'|'1'|'false'|'f'|'no'|'n'|'0'}) ] [ Responses ('response'[,...]) ] [ Accumulate ({ 'accumulate_column' | accumulate_column_range }[,...]) ] )
You can call this function from:
- The FROM clause of a SELECT statement
- As part of a CREATE TABLE statement
- As part of a CREATE VIEW statement