Goden Yao created HAWQ-1047:
-------------------------------
Summary: Push limit clause to PXF
Key: HAWQ-1047
URL: https://issues.apache.org/jira/browse/HAWQ-1047
Project: Apache HAWQ
Issue Type: Improvement
Components: PXF
Reporter: Goden Yao
Assignee: Goden Yao
Fix For: backlog
When user launches an external table query with "limit" clause, Hawq explicitly
closes the remote connection when it has retrieved enough tuples and this
raises an exception on the tomcat end.
In those such queries Hawq doesn't pushdown the limit clause to Pxf so it's up
to Hawq to know when it has enough tuples and end the request.
**expected behavior**
1. HAWQ should push down the limit clause so PXF doesn't need to return more
than the limit number of records.
2. PXF needs handle hawq close connection gracefully.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)