[jira] [Closed] (MADLIB-1184) k-NN install check fails on non-madlib schema name

["Frank McQuillan (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/MADLIB-1184?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Frank McQuillan closed MADLIB-1184.
-----------------------------------

> k-NN install check fails on non-madlib schema name
> --------------------------------------------------
>
>                 Key: MADLIB-1184
>                 URL: https://issues.apache.org/jira/browse/MADLIB-1184
>             Project: Apache MADlib
>          Issue Type: Bug
>          Components: k-NN
>            Reporter: Nandish Jayaram
>             Fix For: v1.13
>
>
> The install check fails when MADlib is installed on a  schema named
> anything other than `madlib`. The issue seems to be because the fn_dist
> param expects a distance function name prefixed with `<madlib_schema>.`
> With MADlib installed on schema `mad`, the following error happens:
> {code}
> psql:/tmp/madlib.OIue8c/knn/test/knn.sql_in.tmp:155: ERROR:  spiexceptions.InvalidSchemaName: schema "madlib" does not exist
> LINE 3:                 oid='madlib.squared_dist_norm2(DOUBLE PRECIS...
>                             ^
> QUERY:  select prorettype != 'DOUBLE PRECISION'::regtype
>                 OR proisagg = TRUE AS OUTPUT from pg_proc where
>                 oid='madlib.squared_dist_norm2(DOUBLE PRECISION[], DOUBLE PRECISION[])'::regprocedure;
> CONTEXT:  Traceback (most recent call last):
>   PL/Python function "knn", line 35, in <module>
>     fn_dist
>   PL/Python function "knn", line 147, in knn
>   PL/Python function "knn", line 100, in knn_validate_src
> {code}



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)