[jira] [Assigned] (HAWQ-762) Hive aggregation queries through PXF sometimes hang

["Kavinder Dhaliwal (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/HAWQ-762?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Kavinder Dhaliwal reassigned HAWQ-762:
--------------------------------------

    Assignee: Kavinder Dhaliwal  (was: Goden Yao)

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