Pivotal HDB (commercial version of Apache Hawq) has been discontinued. You would need to build Apache Hawq from their open source repo http://github.com/apache/incubator-hawq. Here are the instructions for building Hawq https://cwiki.apache.org/confluence/display/HAWQ/Build+and+Install ... View more

@grabowski14 What kind of platform is your Hadoop cluster running under (e.g. OSX, Centos6, etc)? You must have PXF server running on all the data-nodes as well as on the name node. It is best if you use Ambari to install HAWQ and PXF as it guides you with the setup. ... View more

Please take a look at pxf-private.classpath to make sure the hive jars have the correct path. Also, take a look at pxf-service.log under tomcat where PXF is running. The above error is being returned from the PXF java server to C client. ... View more

I am running into the same issue. Any ideas? ... View more

Here are some sample entries from my pg_hba.conf for HAWQ master local all all ident host all all 127.0.0.1/28 trust host all gpadmin ::1/128 trust ... View more

It looks like something is running on port 51200 that is blocking PXFwebapp. You may try using: netstat -plan | grep 51200 ... View more

http://hortonworks.com/apache/hawq/ ... View more

Thanks again! Here is what worked for me (using python 2.6.6). Still need to investigate how to run the test from ambari root directory. $ pip install discover $ export PYTHONPATH=~/git/ambari/ambari-common/src/test/python $ cd ~/git/ambari/ambari-server/src/test/python/stacks/2.3/common $ python -m discover -v Test that HAWQSTANDBY is not recommended on a single node cluster ... ok ... ---------------------------------------------------------------------- Ran 21 tests in 0.318s OK ... View more

Hi Artem, Thanks a lot for your input. I was looking to test stack advisor recommendations and validations. e.g. ambari/ambari-server/src/test/python/stacks/2.3/common/test_stack_advisor.py ... View more