Did I find the right examples for you? yes no      Crawl my project      Python Jobs

# ANAPSID.NonBlockingOperators.NestedHashJoinFilter.NestedHashJoinFilter

All Samples(5)  |  Call(4)  |  Derive(0)  |  Import(1)

```from ANAPSID.NonBlockingOperators.SymmetricHashJoin import SymmetricHashJoin
#from ANAPSID.NonBlockingOperators.NestedHashJoin import NestedHashJoin
from ANAPSID.NonBlockingOperators.NestedHashJoinFilter import NestedHashJoinFilter as NestedHashJoin
#from ANAPSID.NonBlockingOperators.NestedHashOptional import NestedHashOptional
from ANAPSID.NonBlockingOperators.NestedHashOptionalFilter import NestedHashOptionalFilter as NestedHashOptional
```
```        # Case 1: left operator is highly selective and right operator is low selective
if not(lowSelectivityLeft) and lowSelectivityRight  and not(isinstance(r, TreePlan)):
n = TreePlan(NestedHashJoin(join_variables), all_variables, l, r)
dependent_join = True
#print "Planner CASE 1: nested loop", type(r)
# Case 2: left operator is low selective and right operator is highly selective
elif lowSelectivityLeft and not(lowSelectivityRight) and not(isinstance(l, TreePlan)):
n = TreePlan(NestedHashJoin(join_variables), all_variables, r, l)
```
```        elif not(lowSelectivityLeft) and lowSelectivityRight  and (not(isinstance(l, TreePlan)) or not(l.operator.__class__.__name__ == "NestedHashJoinFilter" )) and (not(isinstance(r,TreePlan)) or not(r.operator.__class__.__name__ == "Xgjoin" or r.operator.__class__.__name__ == "NestedHashJoinFilter")):
if (isinstance(r,TreePlan) and (set(l.vars) & set(r.operator.vars_left) !=set([])) and (set(l.vars) & set(r.operator.vars_right) !=set([]))):
n = TreePlan(NestedHashJoin(join_variables), all_variables, l, r)
dependent_join = True
elif (isinstance(l,TreePlan) and (set(r.vars)& set(l.operator.vars_left) !=set([])) and   (set(r.vars)& set(l.operator.vars_right) !=set([]))):
n = TreePlan(NestedHashJoin(join_variables), all_variables, l, r)
```