[
https://issues.apache.org/jira/browse/HAWQ-762?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Kavinder Dhaliwal resolved HAWQ-762.
------------------------------------
Resolution: Fixed
Fix Version/s: (was: backlog)
2.1.0.0-incubating
> Hive aggregation queries through PXF sometimes hang
> ---------------------------------------------------
>
> Key: HAWQ-762
> URL: https://issues.apache.org/jira/browse/HAWQ-762
> Project: Apache HAWQ
> Issue Type: Bug
> Components: Hcatalog, PXF
> Affects Versions: 2.0.0.0-incubating
> Reporter: Oleksandr Diachenko
> Assignee: Kavinder Dhaliwal
> Labels: performance
> Fix For: 2.1.0.0-incubating
>
>
> Reproduce Steps:
> {code}
> select count(*) from hcatalog.default.hivetable;
> {code}
> 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 {code}log_min_messages=DEBUG2{code} to see at which step the query
> is stuck
> - try:
> {code}
> curl http://<uri:port>/pxf/ProtocolVersion
> {code}
> 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:
> {code}
> {version: v14}
> {code}
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
