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)