KNN.sql

--Syntax (version 1.2)

SELECT * FROM KNN(
  ON (SELECT 1)
  PARTITION BY 1
  [DOMAIN('host:port')]
  [DATABASE('db_name')]
  [USERID('user_id')]
  [PASSWORD('password')]
  [SSLSETTINGS('SSLsettings')]
  [SSLTRUSTSTOREPASSWORD('SSLtruststorepassword')]
  TRAINING_TABLE('training_table_name')
  TEST_TABLE('test_table_name')
  NUMBERK(k)
  RESPONSECOLUMN('response_column')
  TEST_POINT_KEY('test_id_column')
  DISTANCE_FEATURES('colum1' [,...])
  [VOTING_WEIGHT(voting_weight)]
  [OUTPUT_TABLE('output_table_name')]
  [CUSTOMIZED_DISTANCE('jar_name', 'distance_class_name'])
  [FORCE_MAPREDUCE('force_mapreduce')]
  [PARTITION_BLOCK_SIZE('partition_Block_Size')]
);