[
https://issues.apache.org/jira/browse/HAWQ-1111?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15589936#comment-15589936
]
Oleksandr Diachenko edited comment on HAWQ-1111 at 10/19/16 10:30 PM:
----------------------------------------------------------------------
As for now HAWQ bridge supports only scalar constant in filter push-down. To
support IN operator list constants also needs to be implemented.
Convention for
* scalar constant:
** c<constant data type oid>s<number of bytes for constant>d<bytes>
* list constant(multiple values):
** m<constant data type oid>s<number of item1>d<bytes for item1>s<number of
item2>d<bytes for item2>...s<number of itemN>d<bytes for itemN>
*HAWQ treats IN clause as compund type, i.e. INT2ARRAYOID(1005),
INT4ARRAYOID(1007), TEXTARRAYOID(1009) etc.*
was (Author: odiachenko):
As for now HAWQ bridge supports only scalar constant in filter push-down. To
support IN operator list constants also needs to be implemented.
Convention for
* scalar constant:
** c<constant data type oid>s<number of bytes for constant>d<bytes>
* list constant(multiple values):
** m<constant data type oid>s<number of item1>d<bytes for item1>s<number of
item2>d<bytes for item2>...s<number of itemN>d<bytes for itemN>
*As for now we assume that all values of certain list have the same data type.*
> Support for IN() operator in PXF
> --------------------------------
>
> Key: HAWQ-1111
> URL: https://issues.apache.org/jira/browse/HAWQ-1111
> Project: Apache HAWQ
> Issue Type: New Feature
> Components: PXF
> Reporter: Vineet Goel
> Assignee: Lei Chang
> Fix For: 2.0.1.0-incubating
>
>
> HAWQ PXF external tables should be optimized for IN() operator so that users
> get the benefit of predicate pushdown. In order to achieve this, HAWQ bridge
> must send serialized expression for IN() operator to PXF.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
