[MADLIB-1089] Install check errors on HAWQ 2.2 when install MADlib on non-default schema

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Won't Fix
• Fix Version/s: v1.12
• Component/s: All Modules
• Assignee: Unassigned
• Reporter: Frank McQuillan
• Created: 13/Apr/17 22:32
• Updated: 14/Aug/17 22:23
• Resolved: 14/Aug/17 22:23

Description

Running install-check on a non-default schema in HAWQ 2.2 results in errors for lining and means.

MADlib version: 1.10.0, git revision: rel/v1.9.1-58-ga3863b6, cmake configuration time: Wed Mar  8 19:49:45 UTC 2017, build type: Release, bui
ld system: Linux-2.6.18-238.27.1.el5.hotfix.bz516490, C compiler: gcc 4.4.0, C++ compiler: g++ 4.4.0

 PostgreSQL 8.2.15 (Greenplum Database 4.2.0 build 1) (HAWQ 2.2.0.0 build 4141) on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) 4.8.5 20
150623 (Red Hat 4.8.5-11) compiled on Mar 30 2017 21:45:26

See attached log files and summaries below:

linalg.sql_in

psql:/tmp/madlib.sGu72l/linalg/test/linalg.sql_in.tmp:165: ERROR:  Function "closest_column(double precision[],double precision[],text)": Inval
id distance metric provided: madlib1.squared_dist_norm2. Currently only madlib provided distance functions are supported.

kmeans.sql_in

psql:/tmp/madlib.sGu72l/kmeans/test/kmeans.sql_in.tmp:117: ERROR:  plpy.SPIError: Function "closest_column(double precision[],double precision[
],text)": Invalid distance metric provided: madlib1.squared_dist_norm2. Currently only madlib provided distance functions are supported.  (seg1
 ip-10-32-127-188.ore6.vpc.pivotal.io:40000 pid=483012) (plpython.c:4663)
CONTEXT:  Traceback (most recent call last):
  PL/Python function "internal_compute_kmeanspp_seeding", line 22, in <module>
    return kmeans.compute_kmeanspp_seeding(**globals())
  PL/Python function "internal_compute_kmeanspp_seeding", line 154, in compute_kmeanspp_seeding
  PL/Python function "internal_compute_kmeanspp_seeding", line 415, in update
PL/Python function "internal_compute_kmeanspp_seeding"
SQL statement "SELECT  ( SELECT madlib1.internal_compute_kmeanspp_seeding( '_madlib_kmeanspp_args', '_madlib_kmeanspp_state', textin(regclassou
t( $1 )),  $2 ) )"
PL/pgSQL function "kmeanspp_seeding" line 83 at assignment
SQL statement "SELECT  madlib1.kmeans(  $1 ,  $2 , madlib1.kmeanspp_seeding( $1 ,  $2 ,  $3 ,  $4 , NULL,  $5 ),  $4 ,  $6 ,  $7 ,  $8 )"
PL/pgSQL function "kmeanspp" line 4 at assignment
SQL statement "SELECT  madlib1.kmeanspp( $1 ,  $2 ,  $3 , 'madlib1.squared_dist_norm2'::VARCHAR, 'madlib1.avg'::VARCHAR, 20::INTEGER, 0.001::DO
UBLE PRECISION, 1.0::DOUBLE PRECISION)"
PL/pgSQL function "kmeanspp" line 4 at assignment