[
https://issues.apache.org/jira/browse/HAWQ-762?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Goden Yao updated HAWQ-762:
---------------------------
Description:
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) logs to see if the query request gets to tomcat
- 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}
was:
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.
> 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: Goden Yao
> Labels: performance
> Fix For: backlog
>
>
> 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) logs to see if the query request gets to tomcat
> - 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.4#6332)
