Github user fmcquillan99 commented on the issue:
https://github.com/apache/madlib/pull/315
load data:
```
DROP TABLE IF EXISTS knn_train_data;
CREATE TABLE knn_train_data (
id integer,
data integer[],
label integer -- Integer label means for classification
);
INSERT INTO knn_train_data VALUES
(1, '{1,1}', 1),
(2, '{2,2}', 1),
(3, '{3,3}', 1),
(4, '{4,4}', 1),
(5, '{4,5}', 1),
(6, '{20,50}', 0),
(7, '{10,31}', 0),
(8, '{81,13}', 0),
(9, '{1,111}', 0);
```
run knn to list nearest neighbors only
(without doing classification or regression).
```
DROP TABLE IF EXISTS knn_result_list_neighbors;
SELECT * FROM madlib.knn(
'knn_train_data_reg', -- Table of training data
'data', -- Col name of training data
'id', -- Col Name of id in train data
NULL, -- NULL training labels means just
list neighbors
'knn_test_data', -- Table of test data
'data', -- Col name of test data
'id', -- Col name of id in test data
'knn_result_list_neighbors', -- Output table
3 -- Number of nearest neighbors
);
```
results in error
```
ERROR: plpy.SPIError: column "none" does not exist
LINE 22: ...b_temp_p_col_name68224549_1536338162_43630832__ , None from ...
^
QUERY:
CREATE TEMP TABLE
__madlib_temp_interim_table80328381_1536338162_13726874__ AS
SELECT * FROM (
SELECT row_number() over
(partition by
__madlib_temp_test_id_temp32938499_1536338162_42836514__ order by
__madlib_temp_dist75319423_1536338162_4342866__) AS
__madlib_temp_r77948314_1536338162_302550__,
__madlib_temp_test_id_temp32938499_1536338162_42836514__,
__madlib_temp_train_id51898468_1536338162_48880352__,
CASE WHEN
__madlib_temp_dist75319423_1536338162_4342866__ = 0.0 THEN 1000000.0
ELSE 1.0 /
__madlib_temp_dist75319423_1536338162_4342866__
END AS
__madlib_temp_dist_inverse21927322_1536338162_30562226__
FROM (
SELECT
__madlib_temp_test58595915_1536338162_24414359__.id AS
__madlib_temp_test_id_temp32938499_1536338162_42836514__,
__madlib_temp_train73645570_1536338162_46994036__.id as
__madlib_temp_train_id51898468_1536338162_48880352__,
madlib.squared_dist_norm2(
__madlib_temp_p_col_name68224549_1536338162_43630832__,
__madlib_temp_t_col_name86464547_1536338162_93305987__)
AS
__madlib_temp_dist75319423_1536338162_4342866__
FROM
(
SELECT id , data as
__madlib_temp_p_col_name68224549_1536338162_43630832__ , None from
knn_train_data_reg
)
__madlib_temp_train73645570_1536338162_46994036__,
(
SELECT id ,data as
__madlib_temp_t_col_name86464547_1536338162_93305987__ from knn_test_data
)
__madlib_temp_test58595915_1536338162_24414359__
)
__madlib_temp_x_temp_table56760627_1536338162_7182722__
)
__madlib_temp_y_temp_table96170617_1536338162_37029044__
WHERE
__madlib_temp_y_temp_table96170617_1536338162_37029044__.__madlib_temp_r77948314_1536338162_302550__
<= 3
CONTEXT: Traceback (most recent call last):
PL/Python function "knn", line 33, in <module>
weighted_avg
PL/Python function "knn", line 305, in knn
PL/Python function "knn"
SQL statement "SELECT madlib.knn( $1 , $2 , $3 , $4 , $5 , $6 , $7 , $8 ,
$9 ,TRUE, 'madlib.squared_dist_norm2', FALSE)"
PL/pgSQL function "knn" line 4 at assignment
```
---
