Test Result : OuterJoinSuite

0 failures (±0)
76 tests (±0)
Took 3.5 sec.

All Tests

Test nameDurationStatus
basic full outer join using BroadcastNestedLoopJoin build left (whole-stage-codegen off)56 msPassed
basic full outer join using BroadcastNestedLoopJoin build left (whole-stage-codegen on)77 msPassed
basic full outer join using BroadcastNestedLoopJoin build right (whole-stage-codegen off)52 msPassed
basic full outer join using BroadcastNestedLoopJoin build right (whole-stage-codegen on)81 msPassed
basic full outer join using ShuffledHashJoin (whole-stage-codegen off)48 msPassed
basic full outer join using ShuffledHashJoin (whole-stage-codegen on)45 msPassed
basic full outer join using SortMergeJoin (whole-stage-codegen off)45 msPassed
basic full outer join using SortMergeJoin (whole-stage-codegen on)46 msPassed
basic left outer join using BroadcastHashJoin (whole-stage-codegen off)41 msPassed
basic left outer join using BroadcastHashJoin (whole-stage-codegen on)48 msPassed
basic left outer join using BroadcastNestedLoopJoin build left (whole-stage-codegen off)71 msPassed
basic left outer join using BroadcastNestedLoopJoin build left (whole-stage-codegen on)56 msPassed
basic left outer join using BroadcastNestedLoopJoin build right (whole-stage-codegen off)52 msPassed
basic left outer join using BroadcastNestedLoopJoin build right (whole-stage-codegen on)49 msPassed
basic left outer join using ShuffledHashJoin (whole-stage-codegen off)0.11 secPassed
basic left outer join using ShuffledHashJoin (whole-stage-codegen on)71 msPassed
basic left outer join using SortMergeJoin (whole-stage-codegen off)62 msPassed
basic left outer join using SortMergeJoin (whole-stage-codegen on)87 msPassed
basic right outer join using BroadcastHashJoin (whole-stage-codegen off)41 msPassed
basic right outer join using BroadcastHashJoin (whole-stage-codegen on)63 msPassed
basic right outer join using BroadcastNestedLoopJoin build left (whole-stage-codegen off)38 msPassed
basic right outer join using BroadcastNestedLoopJoin build left (whole-stage-codegen on)53 msPassed
basic right outer join using BroadcastNestedLoopJoin build right (whole-stage-codegen off)56 msPassed
basic right outer join using BroadcastNestedLoopJoin build right (whole-stage-codegen on)55 msPassed
basic right outer join using ShuffledHashJoin (whole-stage-codegen off)55 msPassed
basic right outer join using ShuffledHashJoin (whole-stage-codegen on)56 msPassed
basic right outer join using SortMergeJoin (whole-stage-codegen off)47 msPassed
basic right outer join using SortMergeJoin (whole-stage-codegen on)66 msPassed
full outer join with both inputs empty using BroadcastNestedLoopJoin build left (whole-stage-codegen off)31 msPassed
full outer join with both inputs empty using BroadcastNestedLoopJoin build left (whole-stage-codegen on)0.13 secPassed
full outer join with both inputs empty using BroadcastNestedLoopJoin build right (whole-stage-codegen off)38 msPassed
full outer join with both inputs empty using BroadcastNestedLoopJoin build right (whole-stage-codegen on)41 msPassed
full outer join with both inputs empty using ShuffledHashJoin (whole-stage-codegen off)30 msPassed
full outer join with both inputs empty using ShuffledHashJoin (whole-stage-codegen on)26 msPassed
full outer join with both inputs empty using SortMergeJoin (whole-stage-codegen off)28 msPassed
full outer join with both inputs empty using SortMergeJoin (whole-stage-codegen on)30 msPassed
left outer join with both inputs empty using BroadcastHashJoin (whole-stage-codegen off)21 msPassed
left outer join with both inputs empty using BroadcastHashJoin (whole-stage-codegen on)29 msPassed
left outer join with both inputs empty using BroadcastNestedLoopJoin build left (whole-stage-codegen off)31 msPassed
left outer join with both inputs empty using BroadcastNestedLoopJoin build left (whole-stage-codegen on)33 msPassed
left outer join with both inputs empty using BroadcastNestedLoopJoin build right (whole-stage-codegen off)22 msPassed
left outer join with both inputs empty using BroadcastNestedLoopJoin build right (whole-stage-codegen on)29 msPassed
left outer join with both inputs empty using ShuffledHashJoin (whole-stage-codegen off)29 msPassed
left outer join with both inputs empty using ShuffledHashJoin (whole-stage-codegen on)37 msPassed
left outer join with both inputs empty using SortMergeJoin (whole-stage-codegen off)24 msPassed
left outer join with both inputs empty using SortMergeJoin (whole-stage-codegen on)52 msPassed
left outer join with unique keys using BroadcastHashJoin (whole-stage-codegen off)46 msPassed
left outer join with unique keys using BroadcastHashJoin (whole-stage-codegen on)57 msPassed
left outer join with unique keys using BroadcastNestedLoopJoin build left (whole-stage-codegen off)58 msPassed
left outer join with unique keys using BroadcastNestedLoopJoin build left (whole-stage-codegen on)65 msPassed
left outer join with unique keys using BroadcastNestedLoopJoin build right (whole-stage-codegen off)35 msPassed
left outer join with unique keys using BroadcastNestedLoopJoin build right (whole-stage-codegen on)33 msPassed
left outer join with unique keys using ShuffledHashJoin (whole-stage-codegen off)61 msPassed
left outer join with unique keys using ShuffledHashJoin (whole-stage-codegen on)55 msPassed
left outer join with unique keys using SortMergeJoin (whole-stage-codegen off)50 msPassed
left outer join with unique keys using SortMergeJoin (whole-stage-codegen on)48 msPassed
right outer join with both inputs empty using BroadcastHashJoin (whole-stage-codegen off)24 msPassed
right outer join with both inputs empty using BroadcastHashJoin (whole-stage-codegen on)32 msPassed
right outer join with both inputs empty using BroadcastNestedLoopJoin build left (whole-stage-codegen off)70 msPassed
right outer join with both inputs empty using BroadcastNestedLoopJoin build left (whole-stage-codegen on)24 msPassed
right outer join with both inputs empty using BroadcastNestedLoopJoin build right (whole-stage-codegen off)32 msPassed
right outer join with both inputs empty using BroadcastNestedLoopJoin build right (whole-stage-codegen on)30 msPassed
right outer join with both inputs empty using ShuffledHashJoin (whole-stage-codegen off)24 msPassed
right outer join with both inputs empty using ShuffledHashJoin (whole-stage-codegen on)39 msPassed
right outer join with both inputs empty using SortMergeJoin (whole-stage-codegen off)28 msPassed
right outer join with both inputs empty using SortMergeJoin (whole-stage-codegen on)64 msPassed
right outer join with unique keys using BroadcastHashJoin (whole-stage-codegen off)34 msPassed
right outer join with unique keys using BroadcastHashJoin (whole-stage-codegen on)40 msPassed
right outer join with unique keys using BroadcastNestedLoopJoin build left (whole-stage-codegen off)29 msPassed
right outer join with unique keys using BroadcastNestedLoopJoin build left (whole-stage-codegen on)27 msPassed
right outer join with unique keys using BroadcastNestedLoopJoin build right (whole-stage-codegen off)45 msPassed
right outer join with unique keys using BroadcastNestedLoopJoin build right (whole-stage-codegen on)43 msPassed
right outer join with unique keys using ShuffledHashJoin (whole-stage-codegen off)49 msPassed
right outer join with unique keys using ShuffledHashJoin (whole-stage-codegen on)58 msPassed
right outer join with unique keys using SortMergeJoin (whole-stage-codegen off)39 msPassed
right outer join with unique keys using SortMergeJoin (whole-stage-codegen on)41 msPassed