TD_KNN(
ON { table | view | (query) } AS TestTable PARTITION BY ANY
ON { table | view | (query) } AS TrainingTable DIMENSION
USING
IDColumn('id_col_name')
InputColumns({'target_column'| target_column_range}[...])
[ ModelType('classification'|'regression'|'neighbors') ]
[ K(k) ]
[ Accumulate({'accumulate_column'|accumulate_column_range}[,...]) ]
[ ResponseColumn(['response_column']) ]
[ VotingWeight(voting_weight) ]
[ Tolerance(tolerance) ]
[ OutputProb('true'|'false'|'t'|'yes'|'y'|'1'|'f'|'no'|'n'|'0') ]
[ Responses('response_list') ]
[ EmitNeighbors('true'|'false'|'t'|'yes'|'y'|'1'|'f'|'no'|'n'|'0') ]
[ EmitDistances('true'|'false'|'t'|'yes'|'y'|'1'|'f'|'no'|'n'|'0') ]
)
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