hawq-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From sequoiadb <mailing-list-r...@sequoiadb.com>
Subject question about using PXF
Date Wed, 28 Oct 2015 08:49:37 GMT
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

 
Mime
View raw message