[
https://issues.apache.org/jira/browse/MADLIB-1184?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16275009#comment-16275009
]
ASF GitHub Bot commented on MADLIB-1184:
----------------------------------------
Github user asfgit closed the pull request at:
https://github.com/apache/madlib/pull/207
> 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)
