hawq-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Goden Yao (JIRA)" <j...@apache.org>
Subject [jira] [Created] (HAWQ-1047) Push limit clause to PXF
Date Tue, 13 Sep 2016 19:01:20 GMT
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

View raw message