bitnine-oss / agensgraph

AgensGraph, a transactional graph database based on PostgreSQL
http://www.agensgraph.org
Other
1.32k stars 146 forks source link

CREATE EXTENSION hadoop_fdw; "$libdir/hadoop_fdw": #415

Open VinACE opened 5 years ago

VinACE commented 5 years ago

=# CREATE EXTENSION hadoop_fdw; ERROR: could not access file "$libdir/hadoop_fdw": No such file or directory # Followed the developer manual at section 9.

=# select* from pg_available_extensions; name | default_version | installed_version | comment ---------------+-----------------+-------------------+----------------------------------------------------------------- hadoop_fdw | 2.5 | | Foreign data wrapper for querying HADOOP

:/usr/local/pgsql/share> ** export HADOOP_FDW_CLASSPATH=/usr/local/pgsql/lib/:/home/ec2-user/agensgraph:/home/ec2-user/agensgraph/contrib:/home/ec2-user/agensgraph/contrib/hadoop_fdw:/home/ec2-user/agensgraph/contrib/:/usr/local/pgsql/share

Not sure what I am i missing here..

I tried to install the below, sudo make install-world # I am on a suse linux

make -C hadoop_fdw install make[2]: Entering directory '/home/ec2-user/agensgraph/contrib/hadoop_fdw' gcc -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Wendif-labels -Wmissing-format-attribute -Wformat-security -fno-strict-aliasing -fwrapv -fexcess-precision=standard -O2 -fPIC -shared -o hadoop_fdw.so hadoop_fdw.o deparse.o hive_funcs.o -L../../src/port -L../../src/common -Wl,--as-needed -Wl,-rpath,'/usr/local/pgsql/lib',--enable-new-dtags -ljvm /usr/lib64/gcc/x86_64-suse-linux/4.8/../../../../x86_64-suse-linux/bin/ld: cannot find -ljvm collect2: error: ld returned 1 exit status ../../src/Makefile.shlib:286: recipe for target 'hadoop_fdw.so' failed make[2]: *** [hadoop_fdw.so] Error 1 make[2]: Leaving directory '/home/ec2-user/agensgraph/contrib/hadoop_fdw'

VinACE commented 5 years ago

In Suse,
sudo ln -s /usr/local/java/jdk1.8.0_181/jre/lib/amd64/server/libjvm.so /usr/local/lib/libjvm.so

sudo make install-world

make[1]: Leaving directory '/home/ec2-user/agensgraph/contrib' PostgreSQL, contrib, and documentation installation complete.