Hadoop FDW requires thrift v0.9.1 (http://thrift.apache.org/)

Make sure you have reviewed and run the THRIFT pre-requisites to compile
http://thrift.apache.org/docs/install/

Unzip the downloaded thrift tarball in your home directory and set
THRIFT_HOME environment variable

   $ cd $HOME
   $ tar -xvf thrift-0.9.1.tar.gz
   $ export THRIFT_HOME=$HOME/thrift-0.9.1
   $ cd $THRIFT_HOME


Set compile flag needed for building thrift and for fb303
   $ export CXXFLAGS="-fPIC"


Configure thrift for compiling on your platform
   $ ./configure --prefix=$THRIFT_HOME --without-csharp --without-java --without-erlang --without-python --without-perl --without-php --without-ruby --without-haskell --without-go


build THRIFT 
   $ make
   $ make install

build FB303
   $ cd contrib/fb303
   $ ./bootstrap.sh
   $ export CPPFLAGS="-I$THRIFT_HOME/include -fPIC"
   $ ./configure --prefix=$THRIFT_HOME --with-thriftpath=$THRIFT_HOME
   $ make
   $ sudo make install

Unzip the downloaded postgresql tarball in your home directory

   $ cd $HOME
   $ tar -xvf postgresql-9.3.5.tar.gz
   $ cd ~/postgresql-9.3.5
   $ ./configure --prefix=$PWD --enable-depend --enable-cassert --enable-debug
   $ make
   $ make install

Put the bin directory of this postgresql build at the front of your path and
test if correct

   $ export PATH=$PWD/bin:$PATH
   $ psql --version
        psql (PostgreSQL) 9.3.5

   $ cd contrib
   $ git clone https://userid@bitbucket.org/openscg/hadoop_fdw.git

   $ make clean-hive-client
   $ make hive_client

   $ make clean-hbase-client
   $ make hbase_client

   $ make
   $ make install

   $ cd $THRIFT_HOME/lib
   $ mv libthrift-0.9.1.so ~/postgresql-9.3.4/lib/

   $ tar -xvf bigsql-5.1-linux64.tar.bz2
   $ cd bigsql-5.1
   $ ./bigsql start

 You can now create the "example.customer_history" table in Hive

   $  . ./setENV.sh
   $  cd examples/
   $  ./createDelimFiles.sh
   $  ./createHdfsDirectories.sh
   $  hive -v -f createHiveTables.sql
   $  hive -v -f loadHiveTables.sql

  $ cd ../../bin
  $ ./initdb -D ../data
  $ ./pg_ctl start -D ../data -o "-p 5433" -l logfile


Next run psql & setup the FDW

  $ ./psql -U user -p 5433 postgres

    postgres=# CREATE EXTENSION hadoop_fdw;

    postgres=# 
      CREATE SERVER hadoop_server FOREIGN DATA WRAPPER hadoop_fdw 
        OPTIONS (address '127.0.0.1', port '10000');

    postgres=# CREATE USER MAPPING FOR PUBLIC SERVER hadoop_server;

Then create & query the foreign table

    postgres=# 
      CREATE FOREIGN TABLE customer_history (
        hist_id  INT,  
        h_c_id   INT,
        h_c_d_id INT,
        h_c_w_id INT,
        h_d_id   INT,
        h_w_id   INT,
        h_date   TIMESTAMP,
        h_amount DECIMAL,
        h_data   TEXT )
      SERVER hadoop_server
      OPTIONS (table 'example.customer_history');

    postgres=# SELECT hist_id, h_date, h_amount FROM customer_history LIMIT 3;

       hist_id |         h_date          | h_amount 
      ---------+-------------------------+----------
             1 | 2013-08-13 03:56:56.522 |       10
             2 | 2013-08-13 03:56:56.534 |       10
             3 | 2013-08-13 03:56:56.534 |       10
      (3 rows)

    postgres=> set hadoop_fdw.hadoop_rowscanthreshold to 100;
    SET

You have to run ANALYZE first on the table in order to collect table 
statistics including the number of rows in the table.

    postgres=> analyze customer_history;
    ANALYZE

Note:  Currently, Hive does not report back valid  statistics for the number
of rows.  It  turns out to  be zero always.  The workaround  is to  set  GUC 
hadoop_fdw.hadoop_rowscanthreshold  to 0 in  order to instruct hadoop_fdw to
push down WHERE clauses down to Hive.

Here is a detailed listing of the functions supported by hadoop_fdw:-

Aggregate Functions:
  avg
  corr
  count
  covar_pop
  covar_samp
  max
  min
  stddev_pop
  stddev_samp
  sum
  var_pop
  var_samp
  variance

Array Functions:
  unnest

Date/Time Functions:
  date_mii
  date_part
  date_pli
  to_timestamp

Mathematical Functions:
  abs
  ceil
  ceiling   
  degrees
  exp
  floor
  ln
  log
  mod
  pi
  power
  radians
  random
  round
  sign
  sqrt

String Functions:
  ascii
  concat
  concat_ws
  length
  lower
  lpad
  ltrim
  repeat
  reverse
  rpad
  rtrim
  strpos
  substr
  to_hex
  translate
  trim
  upper

Trigonometric Functions:
  acos
  asin
  atan
  cos
  sin
  tan