You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@hawq.apache.org by "Goden Yao (JIRA)" <ji...@apache.org> on 2016/09/13 19:01:20 UTC

[jira] [Created] (HAWQ-1047) Push limit clause to PXF

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)