You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hawq.apache.org by "Goden Yao (JIRA)" <ji...@apache.org> on 2016/09/14 21:37:22 UTC

[jira] [Updated] (HAWQ-967) Extend Projection info to include filter attributes

     [ https://issues.apache.org/jira/browse/HAWQ-967?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Goden Yao updated HAWQ-967:
---------------------------
    Fix Version/s:     (was: backlog)
                   2.0.1.0-incubating

> Extend Projection info to include filter attributes
> ---------------------------------------------------
>
>                 Key: HAWQ-967
>                 URL: https://issues.apache.org/jira/browse/HAWQ-967
>             Project: Apache HAWQ
>          Issue Type: Sub-task
>          Components: PXF
>            Reporter: Shivram Mani
>            Assignee: Oleksandr Diachenko
>            Priority: Blocker
>             Fix For: 2.0.1.0-incubating
>
>
> HAWQ-927 includes query projection columns as part of the projection info sent from HAWQ to PXF.
> For queries where filter attributes are different from projection attributes, PXF would return data with NULL values in the filter attributes.
> e.g. a table "test" has 2 columns say: c1 int, c2 int
> {code}
> select c1 from test where c2 > 0;
> {code}
> In the case above, as c2 is not in column projection, pxf will return records like (1, NULL), (2, NULL) ... as part of the implementation in HAWQ-927 
> Due to this HAWQ wouldn't have the necessary data to carry out filters once it receives data back from the underlying external dataset. via PXF and wrong result will be returned to users
> The projection information must be a union of the internal HAWQ projection info and the attributes in the filters.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)