[HAWQ-762] Hive aggregation queries through PXF sometimes hang

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 2.0.0.0-incubating
• Fix Version/s: 2.1.0.0-incubating
• Component/s: Hcatalog, PXF
• Labels: performance
• Assignee: Kavinder Dhaliwal
• Reporter: Oleksandr Diachenko
• Created: 27/May/16 21:38
• Updated: 18/Feb/17 05:27
• Resolved: 13/Feb/17 19:23

Description

Reproduce Steps:

select count(*) from hcatalog.default.hivetable;

sometimes, this query will hang and we see from pxf logs that Hive thrift server cannot be connected from PXF agent.
While users can still visit hive metastore (through HUE) and execute the same query.

After a restart of PXF agent, this query goes through without issues.

Troubleshooting Guide

• check catalina.out (tomcat) and pxf-service.log to see if the query request gets to tomcat/pxf webapp, any exceptions happened during the time window
• enable

  log_min_messages=DEBUG2

  to see at which step the query is stuck

• try:

  curl http://<uri:port>/pxf/ProtocolVersion
  

  where URI is the hostname or IP of the machine you installed PXF, port is usually 51200 if you didn’t change it.
  The response you’ll get if PXF service is running OK:

  {version: v14}
  

Issue Links

• links to: GitHub Pull Request #1075