[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)
[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:
---
Description:
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.
was:
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.
{code}
select c1 from table where c2 > 0;
{code}
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
The projection information must be a union of the internal HAWQ projection info
and the attributes in the filters.
> 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
> 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)
[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:
---
Priority: Blocker (was: Major)
> 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)
[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:
---
Description:
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.
{code}
select c1 from table where c2 > 0;
{code}
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
The projection information must be a union of the internal HAWQ projection info
and the attributes in the filters.
was:
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.
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
The projection information must be a union of the internal HAWQ projection info
and the attributes in the filters.
> 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
> 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.
> {code}
> select c1 from table where c2 > 0;
> {code}
> 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
> 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)
