2.1.0
User Documentation for Apache MADlib
knn.sql_in File Reference

Set of functions for k-nearest neighbors. More...

Functions

integer __knn_validate_src (varchar point_source, varchar point_column_name, varchar label_column_name, varchar test_source, varchar test_column_name, varchar test_id, varchar output_table, integer k, boolean output_neighbors, varchar fn_dist)
 
varchar knn (varchar point_source, varchar point_column_name, varchar point_id, varchar label_column_name, varchar test_source, varchar test_column_name, varchar test_id, varchar output_table, integer k, boolean output_neighbors, text fn_dist, boolean weighted_avg, varchar algorithm, varchar algorithm_params)
 
varchar knn (varchar point_source, varchar point_column_name, varchar point_id, varchar label_column_name, varchar test_source, varchar test_column_name, varchar test_id, varchar output_table, integer k, boolean output_neighbors, text fn_dist, boolean weighted_avg, varchar algorithm)
 
varchar knn (varchar point_source, varchar point_column_name, varchar point_id, varchar label_column_name, varchar test_source, varchar test_column_name, varchar test_id, varchar output_table, integer k, boolean output_neighbors, text fn_dist, boolean weighted_avg)
 
varchar knn (varchar point_source, varchar point_column_name, varchar point_id, varchar label_column_name, varchar test_source, varchar test_column_name, varchar test_id, varchar output_table, integer k, boolean output_neighbors, text fn_dist)
 
varchar knn (varchar point_source, varchar point_column_name, varchar point_id, varchar label_column_name, varchar test_source, varchar test_column_name, varchar test_id, varchar output_table, integer k, boolean output_neighbors)
 
varchar knn (varchar point_source, varchar point_column_name, varchar point_id, varchar label_column_name, varchar test_source, varchar test_column_name, varchar test_id, varchar output_table, integer k)
 
varchar knn (varchar point_source, varchar point_column_name, varchar point_id, varchar label_column_name, varchar test_source, varchar test_column_name, varchar test_id, varchar output_table)
 
varchar knn (varchar message)
 
varchar knn ()
 

Detailed Description

Licensed to the Apache Software Foundation (ASF) under one or more contributor license agreements. See the NOTICE file distributed with this work for additional information regarding copyright ownership. The ASF licenses this file to you under the Apache License, Version 2.0 (the "License"); you may not use this file except in compliance with the License. You may obtain a copy of the License at

http://www.apache.org/licenses/LICENSE-2.0

Unless required by applicable law or agreed to in writing, software distributed under the License is distributed on an "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the License for the specific language governing permissions and limitations under the License.

See also
For a brief introduction to k-nearest neighbors algorithm for regression and classification, see the module description k-Nearest Neighbors.

Function Documentation

◆ __knn_validate_src()

integer __knn_validate_src ( varchar  point_source,
varchar  point_column_name,
varchar  label_column_name,
varchar  test_source,
varchar  test_column_name,
varchar  test_id,
varchar  output_table,
integer  k,
boolean  output_neighbors,
varchar  fn_dist 
)

◆ knn() [1/9]

varchar knn ( varchar  point_source,
varchar  point_column_name,
varchar  point_id,
varchar  label_column_name,
varchar  test_source,
varchar  test_column_name,
varchar  test_id,
varchar  output_table,
integer  k,
boolean  output_neighbors,
text  fn_dist,
boolean  weighted_avg,
varchar  algorithm,
varchar  algorithm_params 
)

◆ knn() [2/9]

varchar knn ( varchar  point_source,
varchar  point_column_name,
varchar  point_id,
varchar  label_column_name,
varchar  test_source,
varchar  test_column_name,
varchar  test_id,
varchar  output_table,
integer  k,
boolean  output_neighbors,
text  fn_dist,
boolean  weighted_avg,
varchar  algorithm 
)

◆ knn() [3/9]

varchar knn ( varchar  point_source,
varchar  point_column_name,
varchar  point_id,
varchar  label_column_name,
varchar  test_source,
varchar  test_column_name,
varchar  test_id,
varchar  output_table,
integer  k,
boolean  output_neighbors,
text  fn_dist,
boolean  weighted_avg 
)

◆ knn() [4/9]

varchar knn ( varchar  point_source,
varchar  point_column_name,
varchar  point_id,
varchar  label_column_name,
varchar  test_source,
varchar  test_column_name,
varchar  test_id,
varchar  output_table,
integer  k,
boolean  output_neighbors,
text  fn_dist 
)

◆ knn() [5/9]

varchar knn ( varchar  point_source,
varchar  point_column_name,
varchar  point_id,
varchar  label_column_name,
varchar  test_source,
varchar  test_column_name,
varchar  test_id,
varchar  output_table,
integer  k,
boolean  output_neighbors 
)

◆ knn() [6/9]

varchar knn ( varchar  point_source,
varchar  point_column_name,
varchar  point_id,
varchar  label_column_name,
varchar  test_source,
varchar  test_column_name,
varchar  test_id,
varchar  output_table,
integer  k 
)

◆ knn() [7/9]

varchar knn ( varchar  point_source,
varchar  point_column_name,
varchar  point_id,
varchar  label_column_name,
varchar  test_source,
varchar  test_column_name,
varchar  test_id,
varchar  output_table 
)

◆ knn() [8/9]

varchar knn ( varchar  message)

◆ knn() [9/9]

varchar knn ( )