Your table definition:
('pxf://my-hadoop-cluster:*50070*/foo_bar?profile=HdfsTextSimple')
if you installed pxf on 51200, you need to use the port 51200On Thu, Mar 10, 2016 at 10:34 AM Gagan Brahmi <[email protected]> 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 >
