Skip to content
This repository has been archived by the owner on Mar 24, 2022. It is now read-only.

ERROR: schema "madlib" does not exist #13

Open
aloth opened this issue Feb 1, 2016 · 2 comments
Open

ERROR: schema "madlib" does not exist #13

aloth opened this issue Feb 1, 2016 · 2 comments

Comments

@aloth
Copy link

aloth commented Feb 1, 2016

For some reason non of my users (not even gpadmin) can access the madlib schema. Does this schema need to be created/enabled first?

tutorial=# SELECT (MADlib.one_way_anova (
tutorial(# CASE WHEN carrier = 'US' THEN 1
tutorial(# WHEN carrier = 'DL' THEN 2
tutorial(# ELSE NULL
tutorial(# END,
tutorial(# arrdelayminutes
tutorial(# )).* FROM faa.otp_r;
ERROR: schema "madlib" does not exist
LINE 1: SELECT (MADlib.one_way_anova (
^

@yahavb
Copy link

yahavb commented May 9, 2016

Same here, even after manually installing madlib on the image:
wget https://dist.apache.org/repos/dist/release/incubator/madlib/1.9-incubating/apache-madlib-1.9-incubating-bin-Linux.rpm
sudo rpm -hiv apache-madlib-1.9-incubating-bin-Linux.rpm
stop_all.sh
start_all.sh

It still can't find MADlib when trying:
%psql.sql SELECT (MADlib.one_way_anova (
CASE WHEN carrier = 'US' THEN 1
WHEN carrier = 'DL' THEN 2
ELSE NULL
END,
arrdelayminutes
)).* FROM faa.otp_r;

@yahavb
Copy link

yahavb commented May 9, 2016

actually just resolved it.
The madly was not installed so I had to download it from:https://network.pivotal.io/. more specifically https://network.pivotal.io/products/pivotal-gpdb#/releases/1683/file_groups/250
Then unpack the tar file and used the gppkg command.
gppkg -i madlib-ossv1.9_pv1.9.5_gpdb4.3orca-rhel5-x86_64.gppkg

The I linked the madlib to the tutorial database:
$GPHOME/madlib/bin/madpack install -s madlib -p greenplum -c gpadmin@localhost:5432/tutorial

and everything worked like a charm through Zeppelin.

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants