Pivotal Knowledge Base

Follow

How To Handle MADlib Install Check Failure

Environment

 Product  Version
 Pivotal HDB  2.x
 MADlib  1.9

Symptom

MADlib install check utility fails to give the following error: 

ERROR: function array_add(double precision[], double precision[]) does not exist
LINE 3: array_add(an,b),
^
HINT: No function matches the given name and argument types. You may need to add explicit type casts.

 Cause

 MADlib install check utility fails due to a wrong search_path in HAWQ.

Resolution

Setting search_path to the MADlib schema at the session level can address most of the MADlib install check issues. Once logged into PSQL, set the search_path to MADlib schema and execute this script:

[gpadmin@hawq21dn2 ~]$ psql
psql (8.2.15)
Type "help" for help.

gpadmin=#SET search_path To madlib

 

 

 

 

Comments

Powered by Zendesk