Hi sequoiadb, which hawq/pxf version are you using (did you just compile the open source version or it's former pivotal released hawq versions)?
Can you also attach pxf logs for investigation? it's at var/log/gphd/ -Goden On Wed, Oct 28, 2015 at 1:51 AM sequoiadb <[email protected]> wrote: > Hi guys, > > I’m trying to setup PXF for HBase and got the following error: > tpch=# create external table hbase_member ( recordkey bytea, > "address:city" varchar, "address:contry" varchar, "address:province" > varchar, "info:age" int, "info:birthday" varchar, "info:company" varchar ) > location ( 'pxf://cent61:50070/member?PROFILE=HBase') FORMAT 'CUSTOM'( > FORMATTER='pxfwritable_import'); > CREATE EXTERNAL TABLE > tpch=# select * from hbase_member; > ERROR: remote component error (0) from '192.168.31.205:51200': couldn't > connect to host (libchurl.c:852) > > I could successfully create regular tables and perform queries, but when I > try to create pxf tables I’m keep getting error on connecting to port 51200. > > So I tried to start pxf-service and got > [root@cent61 profile.d]# service pxf-service init > Creating instance 'pxf-service' ... > Using separate layout > Creating bin/setenv.sh > Applying template 'base' > Copying template's contents > Applying fragment 'context-fragment.xml' to 'conf/context.xml' > Applying fragment 'server-fragment.xml' to 'conf/server.xml' > Applying fragment 'web-fragment.xml' to 'conf/web.xml' > Applying fragment 'tomcat-users-fragment.xml' > to 'conf/tomcat-users.xml' > Applying fragment 'catalina-fragment.properties' > to 'conf/catalina.properties' > Applying template 'base-tomcat-7' > Copying template's contents > Applying fragment 'server-fragment.xml' to 'conf/server.xml' > Applying fragment 'web-fragment.xml' to 'conf/web.xml' > Applying fragment 'catalina-fragment.properties' > to 'conf/catalina.properties' > Applying template 'bio' > Copying template's contents > Applying fragment 'server-fragment.xml' to 'conf/server.xml' > Configuring instance 'pxf-service' to use Tomcat version 7.0.55.A.RELEASE > Setting permissions > Instance created > Connector summary > Port: 51200 Type: Blocking IO Secure: false > [root@cent61 profile.d]# service pxf-service start > /var/gphd/pxf / > Creating home directory for pxf. > Using CATALINA_BASE: /var/gphd/pxf/pxf-service > Using > CATALINA_HOME: > /opt/vmware/vfabric-tc-server-standard/tomcat-7.0.55.A.RELEASE > Using CATALINA_TMPDIR: /var/gphd/pxf/pxf-service/temp > Using JRE_HOME: /usr/jdk64/jdk1.7.0_67 > Using CLASSPATH: > > /opt/vmware/vfabric-tc-server-standard/tomcat-7.0.55.A.RELEASE/bin/bootstrap.jar:/opt/vmware/vfabric-tc-server-standard/tomcat-7.0.55.A.RELEASE/bin/tomcat-juli.jar > Using CATALINA_PID: /var/gphd/pxf/pxf-service/logs/tcserver.pid > Tomcat started. > Status: RUNNING as PID=8385 > / > Checking if tcServer is up and running... > tcServer not responding, re-trying after 1 second (attempt number 1) > tcServer not responding, re-trying after 1 second (attempt number 2) > Checking if PXF webapp is up and running... > ERROR: PXF webapp is inaccessible but tcServer is up. Check logs for more > information > > Now the select statement showing another error: > tpch=# select * from base_member; > ERROR: GPHD component not found (libchurl.c:1058) > > Looks like hit this error: > bool handle_special_error(long response) > { > switch (response) > { > case 404: > elog(ERROR, "GPHD component not found"); > break; > default: > return false; > } > return true; > } > > Now do I need some sort of web service running, in order to make it work? > Is it caused by PXF web app was not able to run? Which log do I supposed > to look? > catalina log showing this and I’m not sure if it’s the right one to look: > 29-Oct-2015 16:37:34.923 SEVERE > [localhost-startStop-1] > org.apache.catalina.core.ContainerBase.addChildInternal > ContainerBase.addChild: > start: > org.apache.catalina.LifecycleException: Failed to > start component > [StandardEngine[Catalina].StandardHost[localhost].StandardContext[/pxf]] > at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:154) > > at > org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901) > at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877) > at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:649) > at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:1083) > > at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1880) > at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471) > at java.util.concurrent.FutureTask.run(FutureTask.java:262) > > at > java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) > > at > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) > at java.lang.Thread.run(Thread.java:745) > Caused by: java.lang.NoClassDefFoundError: Lorg/apache/commons/logging/Log; > at java.lang.Class.getDeclaredFields0(Native Method) > at java.lang.Class.privateGetDeclaredFields(Class.java:2436) > at java.lang.Class.getDeclaredFields(Class.java:1806) > > at > org.apache.catalina.util.Introspection.getDeclaredFields(Introspection.java:106) > > at > org.apache.catalina.startup.WebAnnotationSet.loadFieldsAnnotation(WebAnnotationSet.java:270) > > at > org.apache.catalina.startup.WebAnnotationSet.loadApplicationListenerAnnotations(WebAnnotationSet.java:89) > > at > org.apache.catalina.startup.WebAnnotationSet.loadApplicationAnnotations(WebAnnotationSet.java:63) > > at > org.apache.catalina.startup.ContextConfig.applicationAnnotationsConfig(ContextConfig.java:403) > > at > org.apache.catalina.startup.ContextConfig.configureStart(ContextConfig.java:879) > > at > org.apache.catalina.startup.ContextConfig.lifecycleEvent(ContextConfig.java:374) > > at > org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:117) > > at > org.apache.catalina.util.LifecycleBase.fireLifecycleEvent(LifecycleBase.java:90) > > at > org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5378) > at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150) > ... 10 more > Caused by: java.lang.ClassNotFoundException: org.apache.commons.logging.Log > > at > org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1720) > > at > org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1571) > ... 24 more > > 29-Oct-2015 16:37:34.924 SEVERE > [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployWAR > Error deploying web application archive > /var/gphd/pxf/pxf-service/webapps/pxf.war > java.lang.IllegalStateException: ContainerBase.addChild: > start: org.apache.catalina.LifecycleException: Failed to > start component > [StandardEngine[Catalina].StandardHost[localhost].StandardContext[/pxf]] > > at > org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:904) > at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877) > at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:649) > at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:1083) > > at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1880) > at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471) > at java.util.concurrent.FutureTask.run(FutureTask.java:262) > > at > java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) > > at > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) > at java.lang.Thread.run(Thread.java:745) > > I’m running on a previously built HDP 2.2.8 and performed manual HAWQ > installation. I got most parts done but stuck at PXF component, any help > would be appreciate. > > Thanks > > >
