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 ?
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