CODEWITHSUNDEEP
ambaricloud-foundryhawq
NEO
NEO

Reputation: 399

PIVOTAL HAWQ- PXF connection is not working

We have small Hadoop-HAWQ cluster. in that, when trying to read external table.

prod# select * from ext_table

Getting error:

This pxf error is not letting us read external table via select query. 

 "remote component error (0) from 'xx.xx.xx.xx:51200': couldn't connect to host (libchurl.c:852)"

Tried :

Restarted PXF via ambari and all is Green.

Any help on it would be much appreciated ?

Upvotes: 0

Views: 194

Answers (1)

pratheesh_nair
pratheesh_nair

Reputation: 121

It looks like pxf-service is down in the nodes .Please make sure the pxf service is startedin all the namenodes and datanodes .Also make sure port 51200 is listening and is not bind to any other orphan process .

Please login to pxf nodes via terminal (not through ambari ) .

service pxf-service stop service pxf-service start

To check for orphan process

netstat -anp |grep 51200

kill -9 processid

Thanks Pratheesh Nair

Upvotes: 1

Related Questions