How to install? It is not clear just from the INSTALL text

[peter-telefonica]

We are trying to understand hdfs_fdw/INSTALL... It's not easy (!).

Steps we do:

1. cd /tmp; wget https://github.com/EnterpriseDB/hdfs_fdw/archive/refs/heads/master.zip
2. cd /tmp/hdfs_fdw-master/
3. ... We need to edit export paths, how? What is /path/to/ppas? Where (file and line) I need to include the pg_config path?

    export JDK_INCLUDE:=$JAVA_HOME/include
    export INSTALL_DIR:=/path/to/ppas/install/dir/lib
    export PATH:=/path/to/ppas/install/dir/bin:$PATH

Questions:

Can someone help here (or editing INSTALL) with more explainations?

About Hive's JDBC ... We have a ready-to-use Cloudera JDBC v2-6-5: can we use that? instead of compiling the C++ ... Or is the JDBC-FDW "all in one"?

---

Our context

• Let's assume that we are installing on a SQL-server machine, not on a client (psql).
• We are using a server machine with Red Hat Enterprise Linux release 8
  with JAVA openjdk version "1.8.0_422" and javac 1.8.0_422
• PostgreSQL: v15.3 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 8.5.0 20210514 (Red Hat 8.5.0-18), 64-bit

[sravanvelag]

Hi @peter-telefonica,

Thanks for reaching out to us with your queries.

Can someone help here (or editing INSTALL) with more explainations?

INSTALL_DIR and PATH should point to the lib and the bin folders of the
database server's binary. For example, if postgres is installed at:
/usr/local/pgsql
then
INSTALL_DIR=/usr/local/pgsql/lib
PATH=/usr/local/pgsql/bin:$PATH

Now if you try the command:
which pg_config
on the terminal then it must show:
/usr/local/pgsql/bin/pg_config

About Hive's JDBC ... We have a ready-to-use Cloudera JDBC v2-6-5: can we use that? instead of compiling the C++ ... Or is the JDBC-FDW "all in one"?

We haven’t tested with external hive client jar file. So couldn’t comment. Feel free to try that out and let us know your experience.