Pivotal Knowledge Base


How To Handle MADlib Install Check Failure


 Product  Version
 Pivotal HDB  2.x
 MADlib  1.9


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.


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


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






Powered by Zendesk