[ https://issues.apache.org/jira/browse/MADLIB-1499?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17541793#comment-17541793 ]
seth.qiang commented on MADLIB-1499: ------------------------------------ thanks, [~okislal] I thank I found the answer. I should also save copy of $BUILD_ROOT/build/src/ on the remote host localhost or local port it's ok. remote host need copy build file. I didn't understand this at first. {code:java} ./madpack -s madlib -p greenplum -c gpadmin/12345@localhost:5432/postgres install {code} > madpack install error: libmadlib.so : No such file or directory > --------------------------------------------------------------- > > Key: MADLIB-1499 > URL: https://issues.apache.org/jira/browse/MADLIB-1499 > Project: Apache MADlib > Issue Type: Question > Components: Build System, Madpack > Reporter: seth.qiang > Priority: Major > > Hello everyone, I am referring to the documentation to compile madlib and an > error occurs when installing to greenplum. How should I solve it? > libmadlib.so file exists > > {code:java} > CREATE SCHEMA madlib; > CREATE SCHEMA > DROP TABLE IF EXISTS madlib.migrationhistory; > psql:/tmp/madlib.70V1nQ/madlib_install.sql:2: NOTICE: table > "migrationhistory" does not exist, skipping > DROP TABLE > CREATE TABLE madlib.migrationhistory > (id serial, version varchar(255), > applied timestamp default current_timestamp); > psql:/tmp/madlib.70V1nQ/madlib_install.sql:5: NOTICE: Table doesn't have > 'DISTRIBUTED BY' clause -- Using column named 'id' as the Greenplum Database > data distribution key for this table. > HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make > sure column(s) chosen are the optimal data distribution key to minimize skew. > CREATE TABLEINSERT INTO madlib.migrationhistory(version) > VALUES('1.18.0'); > INSERT 0 1CREATE OR REPLACE FUNCTION madlib.array_add(x anyarray, y anyarray) > RETURNS anyarray > AS '/apache-madlib-1.18.0-src/build/src/ports/greenplum/6/lib/libmadlib.so', > 'array_add' > LANGUAGE C IMMUTABLE > NO SQL; > psql:/tmp/madlib.70V1nQ/madlib_install.sql:23: ERROR: could not access file > "/apache-madlib-1.18.0-src/build/src/ports/greenplum/6/lib/libmadlib.so": No > such file or directory {code} -- This message was sent by Atlassian Jira (v8.20.7#820007)