hawq-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Gagan Brahmi <gaganbra...@gmail.com>
Subject PXF service could not be reached
Date Thu, 10 Mar 2016 18:33:57 GMT
Hi Team,

I was wondering if someone has encountered this problem before.

While trying to work with PXF on hawq 2.0 I am encountering the following error:

gagan=# CREATE EXTERNAL TABLE ext_get_foo (i int, bar text) LOCATION
FORMAT 'text' (delimiter '|' null 'null');

gagan=# SELECT * FROM ext_get_foo ;
ERROR:  remote component error (404): PXF service could not be
reached. PXF is not running in the tomcat container (libchurl.c:878)

The same happens when I try to write to an external table using PXF.

I believe the above error signifies that PXF service isn't running or
unavailable. But PXF is running on port 51200.

Curl response works fine as well:

# curl -s http://localhost:51200/pxf/v0
Wrong version v0, supported version is v14

PXF is build using gradlew and installed as RPM files. I also have
tomcat 7.0.62 installed with the PXF packages.

The following is how PXF is running on the instance:

pxf      21405  0.3  2.8 825224 115164 ?       Sl   02:07   0:10
-Xmx512M -Xss256K -Djava.endorsed.dirs=/var/pxf/pxf-service/endorsed
-classpath /var/pxf/pxf-service/bin/bootstrap.jar:/var/pxf/pxf-service/bin/tomcat-juli.jar
org.apache.catalina.startup.Bootstrap start

I do not have apache-tomcat running. Not sure how are the two
interrelated. But the RPM file created by gradlew requires tomcat for

I would appreciate any inputs into this problem.

Gagan Brahmi

View raw message