[ 
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)

Reply via email to