[jira] [Closed] (QUICKSTEP-76) LIP Filter Does not Work in the distributed version

["Zuyu Zhang (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/QUICKSTEP-76?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Zuyu Zhang closed QUICKSTEP-76.
-------------------------------
    Resolution: Fixed
      Assignee: Zuyu Zhang

> LIP Filter Does not Work in the distributed version
> ---------------------------------------------------
>
>                 Key: QUICKSTEP-76
>                 URL: https://issues.apache.org/jira/browse/QUICKSTEP-76
>             Project: Apache Quickstep
>          Issue Type: Bug
>          Components: Distributed Query Execution
>            Reporter: Zuyu Zhang
>            Assignee: Zuyu Zhang
>         Attachments: test.sql
>
>
> In the distributed version where Ensemble are consist of multiple Shiftboss, a query w/ non-partitioned hash join whose probe relation is non-stored may get incorrect result, because a SelectWorkOrder on a block from the probe relation may be scheduled on a Shiftboss other than the one that has executed BuildHashJoin. Thus the LIP filter in the SelectWorkOrder has not initialized by BuildHashJoin, and would incorrectly produce no outputs.
> There is a quick fix to schedule SelectWorkOrder on the probe relation only on the Shiftboss that has executed BuildHashJoin.
> As for a partitioned hash join, there are two cases. If the stored probe relation does not need repartition, no changes needed (as no SelectWorkOrder needed). Otherwise, each SelectWorkOrder should be scheduled on the Shiftboss that has executed BuildHashWorkOrder with the same partition id.



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)