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/07/26 22:35:20 UTC

[jira] [Comment Edited] (HAWQ-779) support more pxf filter pushdwon

    [ https://issues.apache.org/jira/browse/HAWQ-779?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15394685#comment-15394685 ] 

Goden Yao edited comment on HAWQ-779 at 7/26/16 10:34 PM:
----------------------------------------------------------

reopen as too many issues after testing the feature. [~jiadx] please check HAWQ-953 and HAWQ-950 and provide an updated patch for us to merge in.


was (Author: godenyao):
reopen as too many issues after testing the feature.

>  support more pxf filter pushdwon
> ---------------------------------
>
>                 Key: HAWQ-779
>                 URL: https://issues.apache.org/jira/browse/HAWQ-779
>             Project: Apache HAWQ
>          Issue Type: New Feature
>          Components: PXF
>            Reporter: Devin Jia
>            Assignee: Shivram Mani
>             Fix For: 2.0.1.0-incubating
>
>
> When I use the pxf hawq, I need to read a traditional relational database systems and solr by way of the external table. The project :https://github.com/Pivotal-Field-Engineering/pxf-field/tree/master/jdbc-pxf-ext, only "WriteAccessor ",so I developed 2 plug-ins, the projects: https://github.com/inspur-insight/pxf-plugin , But these two plug-ins need to modified HAWQ:
> 1. When get a list of fragment from pxf services, push down the 'filterString'. modify the backend / optimizer / plan / createplan.c of create_pxf_plan methods:
> segdb_work_map = map_hddata_2gp_segments (uri_str,
> total_segs, segs_participating,
> relation, ctx-> root-> parse-> jointree-> quals);
> 2. modify pxffilters.h and pxffilters.c, support TEXT types LIKE operation, Date type data operator, Float type operator.
> 3. Modify org.apache.hawq.pxf.api.FilterParser.java, support the LIKE operator.
> I already created a feature branch in my local ,and tested.



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