How To Handle MADlib Install Check Failure

Products

• Services Suite

Environment

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