Uploaded image for project: 'Apache HAWQ'
  1. Apache HAWQ
  2. HAWQ-779

support more pxf filter pushdwon

    XMLWordPrintableJSON

    Details

    • Type: New Feature
    • Status: Resolved
    • Priority: Major
    • Resolution: Implemented
    • Affects Version/s: None
    • Fix Version/s: 2.1.0.0-incubating
    • Component/s: PXF
    • Labels:
      None

      Description

      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.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                shivram Shivram Mani
                Reporter:
                jiadx Devin Jia
              • Votes:
                0 Vote for this issue
                Watchers:
                5 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: