Test Result : LeftSemiPushdownSuite

0 failures (±0)
85 tests (±0)
Took 0.23 sec.

All Tests

Test nameDurationStatus
Aggregate: LeftAnti join no pushdown5 msPassed
Aggregate: LeftSemi join partial pushdown6 msPassed
Aggregate: LeftSemiAnti join no pushdown due to non-deterministic aggr expressions3 msPassed
Aggregate: LeftSemiAnti join non-correlated scalar subq aggr exprs9 msPassed
Aggregate: LeftSemiAnti join pushdown7 msPassed
LeftAnti no pushdown - join condition refers both leg - join type Cross2 msPassed
LeftAnti no pushdown - join condition refers both leg - join type Inner2 msPassed
LeftAnti no pushdown - join condition refers both leg - join type LeftOuter2 msPassed
LeftAnti no pushdown - join condition refers both leg - join type RightOuter2 msPassed
LeftAnti no pushdown - join condition refers left leg - join type for RightOuter1 msPassed
LeftAnti no pushdown - join condition refers none of the leg - join type Cross1 msPassed
LeftAnti no pushdown - join condition refers none of the leg - join type Inner2 msPassed
LeftAnti no pushdown - join condition refers none of the leg - join type LeftOuter2 msPassed
LeftAnti no pushdown - join condition refers none of the leg - join type RightOuter2 msPassed
LeftAnti no pushdown - join condition refers right leg - join type for LeftOuter2 msPassed
LeftAnti no pushdown when child join type is FullOuter2 msPassed
LeftAnti pushdown empty join cond join type Cross join cond None1 msPassed
LeftAnti pushdown empty join cond join type Cross join cond Some(('d = 'e))1 msPassed
LeftAnti pushdown empty join cond join type Inner join cond None1 msPassed
LeftAnti pushdown empty join cond join type Inner join cond Some(('d = 'e))2 msPassed
LeftAnti pushdown empty join cond join type LeftOuter join cond None1 msPassed
LeftAnti pushdown empty join cond join type LeftOuter join cond Some(('d = 'e))2 msPassed
LeftAnti pushdown empty join cond join type RightOuter join cond None1 msPassed
LeftAnti pushdown empty join cond join type RightOuter join cond Some(('d = 'e))2 msPassed
LeftAnti pushdown to left of join type: Cross join condition None2 msPassed
LeftAnti pushdown to left of join type: Cross join condition Some(('d = 'e))3 msPassed
LeftAnti pushdown to left of join type: Inner join condition None2 msPassed
LeftAnti pushdown to left of join type: Inner join condition Some(('d = 'e))2 msPassed
LeftAnti pushdown to left of join type: LeftOuter join condition None2 msPassed
LeftAnti pushdown to left of join type: LeftOuter join condition Some(('d = 'e))2 msPassed
LeftAnti pushdown to right of join type: Cross join condition None2 msPassed
LeftAnti pushdown to right of join type: Cross join condition Some(('e = 'd))2 msPassed
LeftAnti pushdown to right of join type: Inner join condition None2 msPassed
LeftAnti pushdown to right of join type: Inner join condition Some(('e = 'd))3 msPassed
LeftAnti pushdown to right of join type: RightOuter join condition None2 msPassed
LeftAnti pushdown to right of join type: RightOuter join condition Some(('e = 'd))2 msPassed
LeftSemi no pushdown - join condition refers both leg - join type Cross2 msPassed
LeftSemi no pushdown - join condition refers both leg - join type Inner2 msPassed
LeftSemi no pushdown - join condition refers both leg - join type LeftOuter2 msPassed
LeftSemi no pushdown - join condition refers both leg - join type RightOuter2 msPassed
LeftSemi no pushdown - join condition refers left leg - join type for RightOuter2 msPassed
LeftSemi no pushdown - join condition refers none of the leg - join type Cross2 msPassed
LeftSemi no pushdown - join condition refers none of the leg - join type Inner2 msPassed
LeftSemi no pushdown - join condition refers none of the leg - join type LeftOuter2 msPassed
LeftSemi no pushdown - join condition refers none of the leg - join type RightOuter2 msPassed
LeftSemi no pushdown - join condition refers right leg - join type for LeftOuter2 msPassed
LeftSemi no pushdown when child join type is FullOuter2 msPassed
LeftSemi pushdown empty join cond join type Cross join cond None1 msPassed
LeftSemi pushdown empty join cond join type Cross join cond Some(('d = 'e))2 msPassed
LeftSemi pushdown empty join cond join type Inner join cond None1 msPassed
LeftSemi pushdown empty join cond join type Inner join cond Some(('d = 'e))2 msPassed
LeftSemi pushdown empty join cond join type LeftOuter join cond None1 msPassed
LeftSemi pushdown empty join cond join type LeftOuter join cond Some(('d = 'e))2 msPassed
LeftSemi pushdown empty join cond join type RightOuter join cond None2 msPassed
LeftSemi pushdown empty join cond join type RightOuter join cond Some(('d = 'e))2 msPassed
LeftSemi pushdown to left of join type: Cross join condition None2 msPassed
LeftSemi pushdown to left of join type: Cross join condition Some(('d = 'e))2 msPassed
LeftSemi pushdown to left of join type: Inner join condition None1 msPassed
LeftSemi pushdown to left of join type: Inner join condition Some(('d = 'e))4 msPassed
LeftSemi pushdown to left of join type: LeftOuter join condition None1 msPassed
LeftSemi pushdown to left of join type: LeftOuter join condition Some(('d = 'e))2 msPassed
LeftSemi pushdown to right of join type: Cross join condition None2 msPassed
LeftSemi pushdown to right of join type: Cross join condition Some(('e = 'd))2 msPassed
LeftSemi pushdown to right of join type: Inner join condition None2 msPassed
LeftSemi pushdown to right of join type: Inner join condition Some(('e = 'd))3 msPassed
LeftSemi pushdown to right of join type: RightOuter join condition None2 msPassed
LeftSemi pushdown to right of join type: RightOuter join condition Some(('e = 'd))2 msPassed
LeftSemiAnti join over Window8 msPassed
LeftSemiAnti join over aggregate - no pushdown4 msPassed
Project: LeftSemiAnti join no pushdown - correlated scalar subq in projection list8 msPassed
Project: LeftSemiAnti join no pushdown because of non-deterministic proj exprs2 msPassed
Project: LeftSemiAnti join non correlated scalar subq7 msPassed
Project: LeftSemiAnti join pushdown4 msPassed
SPARK-34081: LeftAnti only push down if join can be planned as broadcast join5 msPassed
SPARK-34081: LeftSemi only push down if join can be planned as broadcast join6 msPassed
Unary: LeftAnti join pushdown - no pushdown3 msPassed
Unary: LeftSemi join push down through Expand4 msPassed
Unary: LeftSemi join pushdown - partial pushdown6 msPassed
Unary: LeftSemiAnti join pushdown4 msPassed
Unary: LeftSemiAnti join pushdown - empty join condition2 msPassed
Unary: LeftSemiAnti join pushdown - no pushdown4 msPassed
Union: LeftSemiAnti join pushdown5 msPassed
Union: LeftSemiAnti join pushdown in self join scenario4 msPassed
Window: LeftAnti no pushdown8 msPassed
Window: LeftSemi partial pushdown7 msPassed