hawq-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Ting(Goden) Yao" <t...@pivotal.io>
Subject Re: PXF service could not be reached
Date Thu, 10 Mar 2016 18:45:40 GMT
Your table definition:
('pxf://my-hadoop-cluster:*50070*/foo_bar?profile=HdfsTextSimple')
if you installed pxf on 51200, you need to use the port 51200


On Thu, Mar 10, 2016 at 10:34 AM Gagan Brahmi <gaganbrahmi@gmail.com> wrote:

> 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
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message