[
https://issues.apache.org/jira/browse/HAWQ-967?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Oleksandr Diachenko resolved HAWQ-967.
--------------------------------------
Resolution: Fixed
> 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: backlog
>
>
> 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)
