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
