[GitHub] incubator-madlib issue #81: JIRA: MADLIB-927 Changes made in KNN-help messag...

[orhankislal <gi...@git.apache.org>]

Github user orhankislal commented on the issue:

    https://github.com/apache/incubator-madlib/pull/81
  
    When I run the install-check I get the following error. 
    ```
    select * from madlib.knn('knn_train_data','data','label','knn_test_data','data','id','madlib_knn_result_classification','c',3);
    psql:/tmp/madlib.vuBBXN/knn/test/knn.sql_in.tmp:137: ERROR:  mode is not an ordered-set aggregate, so it cannot have WITHIN GROUP
    LINE 3:  select test_id as id, data, mode() within group(order by la...
                                         ^
    QUERY:  
    	CREATE TABLE madlib_knn_result_classification AS
    	select test_id as id, data, mode() within group(order by label) as predLabel from pg_temp.madlib_knn_interm join knn_test_data  on test_id=id group by test_id, data
    CONTEXT:  PL/pgSQL function knn(character varying,character varying,character varying,character varying,character varying,character varying,character varying,character varying,integer) line 44 at EXECUTE statement
    ```
    Have you encountered this before? I am using postgres 9.4.


---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at infrastructure@apache.org or file a JIRA ticket
with INFRA.
---