Pivotal Knowledge Base

Follow

pxf issue on HDB2.0

Environment:

   HDB2.0, HDP2.3

Purpose:

  Issue with pxf on HDB2.0

Problem:

customer has issue below

 
[gpadmin@masternode ~]$ psql
psql (8.2.15)
Type "help" for help.

baypoc=# SELECT * from ext_sales limit 20;
ERROR: remote component error (500) from '192.168.100.11:51200': Wrong version v14, supported version is v12 (libchurl.c:878) (seg9 datanode2.mfec.local:40000 pid=161094) (dispatcher.c:1801)
DETAIL: External table ext_sales, file pxf://masternode.mfec.local:51200/dir/file.txt?profile=HdfsTextSimple

Resolution:

1) "service pxf-service stop" , remove /var/pxf directory
2) "service pxf-service init" & "service pxf-service start"

Root Cause:

when upgrade PXF, sometimes it can fail to update the webapp inside Tomcat itself.As a result, we should manually redeploy these webapps again. 

Comments

Powered by Zendesk