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
('pxf://my-hadoop-cluster:50070/foo_bar?profile=HdfsTextSimple')
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
/usr/java/latest/bin/java
-Djava.util.logging.config.file=/var/pxf/pxf-service/conf/logging.properties
-Djava.util.logging.manager=org.apache.juli.ClassLoaderLogManager
-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
-Dcatalina.base=/var/pxf/pxf-service
-Dcatalina.home=/var/pxf/pxf-service
-Djava.io.tmpdir=/var/pxf/pxf-service/temp
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
pxf-service.

I would appreciate any inputs into this problem.


Regards,
Gagan Brahmi

Mime
View raw message