Test Result : ExistenceJoinSuite

0 failures (±0)
117 tests (±0)
Took 7.2 sec.

All Tests

Test nameDurationStatus
test composed condition (both non-equal) for left anti join using BroadcastHashJoin (whole-stage-codegen off)1 msPassed
test composed condition (both non-equal) for left anti join using BroadcastHashJoin (whole-stage-codegen on)0 msPassed
test composed condition (both non-equal) for left anti join using BroadcastNestedLoopJoin build left76 msPassed
test composed condition (both non-equal) for left anti join using BroadcastNestedLoopJoin build right (whole-stage-codegen off)57 msPassed
test composed condition (both non-equal) for left anti join using BroadcastNestedLoopJoin build right (whole-stage-codegen on)72 msPassed
test composed condition (both non-equal) for left anti join using ShuffledHashJoin (whole-stage-codegen off)0 msPassed
test composed condition (both non-equal) for left anti join using ShuffledHashJoin (whole-stage-codegen on)0 msPassed
test composed condition (both non-equal) for left anti join using SortMergeJoin (whole-stage-codegen off)0 msPassed
test composed condition (both non-equal) for left anti join using SortMergeJoin (whole-stage-codegen on)0 msPassed
test composed condition (both non-equal) for left semi join using BroadcastHashJoin (whole-stage-codegen off)0 msPassed
test composed condition (both non-equal) for left semi join using BroadcastHashJoin (whole-stage-codegen on)0 msPassed
test composed condition (both non-equal) for left semi join using BroadcastNestedLoopJoin build left82 msPassed
test composed condition (both non-equal) for left semi join using BroadcastNestedLoopJoin build right (whole-stage-codegen off)71 msPassed
test composed condition (both non-equal) for left semi join using BroadcastNestedLoopJoin build right (whole-stage-codegen on)86 msPassed
test composed condition (both non-equal) for left semi join using ShuffledHashJoin (whole-stage-codegen off)0 msPassed
test composed condition (both non-equal) for left semi join using ShuffledHashJoin (whole-stage-codegen on)0 msPassed
test composed condition (both non-equal) for left semi join using SortMergeJoin (whole-stage-codegen off)0 msPassed
test composed condition (both non-equal) for left semi join using SortMergeJoin (whole-stage-codegen on)0 msPassed
test composed condition (equal & non-equal) for left semi join using BroadcastHashJoin (whole-stage-codegen off)90 msPassed
test composed condition (equal & non-equal) for left semi join using BroadcastHashJoin (whole-stage-codegen on)84 msPassed
test composed condition (equal & non-equal) for left semi join using BroadcastNestedLoopJoin build left0.1 secPassed
test composed condition (equal & non-equal) for left semi join using BroadcastNestedLoopJoin build right (whole-stage-codegen off)78 msPassed
test composed condition (equal & non-equal) for left semi join using BroadcastNestedLoopJoin build right (whole-stage-codegen on)0.1 secPassed
test composed condition (equal & non-equal) for left semi join using ShuffledHashJoin (whole-stage-codegen off)83 msPassed
test composed condition (equal & non-equal) for left semi join using ShuffledHashJoin (whole-stage-codegen on)0.11 secPassed
test composed condition (equal & non-equal) for left semi join using SortMergeJoin (whole-stage-codegen off)78 msPassed
test composed condition (equal & non-equal) for left semi join using SortMergeJoin (whole-stage-codegen on)97 msPassed
test composed condition (equal & non-equal) test for left anti join using BroadcastHashJoin (whole-stage-codegen off)58 msPassed
test composed condition (equal & non-equal) test for left anti join using BroadcastHashJoin (whole-stage-codegen on)77 msPassed
test composed condition (equal & non-equal) test for left anti join using BroadcastNestedLoopJoin build left80 msPassed
test composed condition (equal & non-equal) test for left anti join using BroadcastNestedLoopJoin build right (whole-stage-codegen off)54 msPassed
test composed condition (equal & non-equal) test for left anti join using BroadcastNestedLoopJoin build right (whole-stage-codegen on)67 msPassed
test composed condition (equal & non-equal) test for left anti join using ShuffledHashJoin (whole-stage-codegen off)72 msPassed
test composed condition (equal & non-equal) test for left anti join using ShuffledHashJoin (whole-stage-codegen on)89 msPassed
test composed condition (equal & non-equal) test for left anti join using SortMergeJoin (whole-stage-codegen off)78 msPassed
test composed condition (equal & non-equal) test for left anti join using SortMergeJoin (whole-stage-codegen on)0.11 secPassed
test composed unique condition (both non-equal) for left anti join using BroadcastHashJoin (whole-stage-codegen off)59 msPassed
test composed unique condition (both non-equal) for left anti join using BroadcastHashJoin (whole-stage-codegen on)81 msPassed
test composed unique condition (both non-equal) for left anti join using BroadcastNestedLoopJoin build left82 msPassed
test composed unique condition (both non-equal) for left anti join using BroadcastNestedLoopJoin build right (whole-stage-codegen off)58 msPassed
test composed unique condition (both non-equal) for left anti join using BroadcastNestedLoopJoin build right (whole-stage-codegen on)58 msPassed
test composed unique condition (both non-equal) for left anti join using ShuffledHashJoin (whole-stage-codegen off)64 msPassed
test composed unique condition (both non-equal) for left anti join using ShuffledHashJoin (whole-stage-codegen on)62 msPassed
test composed unique condition (both non-equal) for left anti join using SortMergeJoin (whole-stage-codegen off)77 msPassed
test composed unique condition (both non-equal) for left anti join using SortMergeJoin (whole-stage-codegen on)81 msPassed
test no condition with empty right side for left anti join using BroadcastHashJoin (whole-stage-codegen off)0 msPassed
test no condition with empty right side for left anti join using BroadcastHashJoin (whole-stage-codegen on)0 msPassed
test no condition with empty right side for left anti join using BroadcastNestedLoopJoin build left71 msPassed
test no condition with empty right side for left anti join using BroadcastNestedLoopJoin build right (whole-stage-codegen off)50 msPassed
test no condition with empty right side for left anti join using BroadcastNestedLoopJoin build right (whole-stage-codegen on)55 msPassed
test no condition with empty right side for left anti join using ShuffledHashJoin (whole-stage-codegen off)0 msPassed
test no condition with empty right side for left anti join using ShuffledHashJoin (whole-stage-codegen on)0 msPassed
test no condition with empty right side for left anti join using SortMergeJoin (whole-stage-codegen off)0 msPassed
test no condition with empty right side for left anti join using SortMergeJoin (whole-stage-codegen on)0 msPassed
test no condition with empty right side for left semi join using BroadcastHashJoin (whole-stage-codegen off)0 msPassed
test no condition with empty right side for left semi join using BroadcastHashJoin (whole-stage-codegen on)0 msPassed
test no condition with empty right side for left semi join using BroadcastNestedLoopJoin build left62 msPassed
test no condition with empty right side for left semi join using BroadcastNestedLoopJoin build right (whole-stage-codegen off)51 msPassed
test no condition with empty right side for left semi join using BroadcastNestedLoopJoin build right (whole-stage-codegen on)48 msPassed
test no condition with empty right side for left semi join using ShuffledHashJoin (whole-stage-codegen off)1 msPassed
test no condition with empty right side for left semi join using ShuffledHashJoin (whole-stage-codegen on)0 msPassed
test no condition with empty right side for left semi join using SortMergeJoin (whole-stage-codegen off)0 msPassed
test no condition with empty right side for left semi join using SortMergeJoin (whole-stage-codegen on)0 msPassed
test no condition with non-empty right side for left anti join using BroadcastHashJoin (whole-stage-codegen off)0 msPassed
test no condition with non-empty right side for left anti join using BroadcastHashJoin (whole-stage-codegen on)0 msPassed
test no condition with non-empty right side for left anti join using BroadcastNestedLoopJoin build left76 msPassed
test no condition with non-empty right side for left anti join using BroadcastNestedLoopJoin build right (whole-stage-codegen off)64 msPassed
test no condition with non-empty right side for left anti join using BroadcastNestedLoopJoin build right (whole-stage-codegen on)72 msPassed
test no condition with non-empty right side for left anti join using ShuffledHashJoin (whole-stage-codegen off)0 msPassed
test no condition with non-empty right side for left anti join using ShuffledHashJoin (whole-stage-codegen on)0 msPassed
test no condition with non-empty right side for left anti join using SortMergeJoin (whole-stage-codegen off)0 msPassed
test no condition with non-empty right side for left anti join using SortMergeJoin (whole-stage-codegen on)0 msPassed
test no condition with non-empty right side for left semi join using BroadcastHashJoin (whole-stage-codegen off)0 msPassed
test no condition with non-empty right side for left semi join using BroadcastHashJoin (whole-stage-codegen on)1 msPassed
test no condition with non-empty right side for left semi join using BroadcastNestedLoopJoin build left0.13 secPassed
test no condition with non-empty right side for left semi join using BroadcastNestedLoopJoin build right (whole-stage-codegen off)79 msPassed
test no condition with non-empty right side for left semi join using BroadcastNestedLoopJoin build right (whole-stage-codegen on)68 msPassed
test no condition with non-empty right side for left semi join using ShuffledHashJoin (whole-stage-codegen off)6 msPassed
test no condition with non-empty right side for left semi join using ShuffledHashJoin (whole-stage-codegen on)1 msPassed
test no condition with non-empty right side for left semi join using SortMergeJoin (whole-stage-codegen off)0 msPassed
test no condition with non-empty right side for left semi join using SortMergeJoin (whole-stage-codegen on)0 msPassed
test single condition (equal) for left anti join using BroadcastHashJoin (whole-stage-codegen off)86 msPassed
test single condition (equal) for left anti join using BroadcastHashJoin (whole-stage-codegen on)0.1 secPassed
test single condition (equal) for left anti join using BroadcastNestedLoopJoin build left88 msPassed
test single condition (equal) for left anti join using BroadcastNestedLoopJoin build right (whole-stage-codegen off)58 msPassed
test single condition (equal) for left anti join using BroadcastNestedLoopJoin build right (whole-stage-codegen on)67 msPassed
test single condition (equal) for left anti join using ShuffledHashJoin (whole-stage-codegen off)83 msPassed
test single condition (equal) for left anti join using ShuffledHashJoin (whole-stage-codegen on)99 msPassed
test single condition (equal) for left anti join using SortMergeJoin (whole-stage-codegen off)86 msPassed
test single condition (equal) for left anti join using SortMergeJoin (whole-stage-codegen on)0.1 secPassed
test single condition (equal) for left semi join using BroadcastHashJoin (whole-stage-codegen off)75 msPassed
test single condition (equal) for left semi join using BroadcastHashJoin (whole-stage-codegen on)75 msPassed
test single condition (equal) for left semi join using BroadcastNestedLoopJoin build left86 msPassed
test single condition (equal) for left semi join using BroadcastNestedLoopJoin build right (whole-stage-codegen off)62 msPassed
test single condition (equal) for left semi join using BroadcastNestedLoopJoin build right (whole-stage-codegen on)63 msPassed
test single condition (equal) for left semi join using ShuffledHashJoin (whole-stage-codegen off)0.11 secPassed
test single condition (equal) for left semi join using ShuffledHashJoin (whole-stage-codegen on)0.1 secPassed
test single condition (equal) for left semi join using SortMergeJoin (whole-stage-codegen off)96 msPassed
test single condition (equal) for left semi join using SortMergeJoin (whole-stage-codegen on)0.1 secPassed
test single unique condition (equal) for left anti join using BroadcastHashJoin (whole-stage-codegen off)0.11 secPassed
test single unique condition (equal) for left anti join using BroadcastHashJoin (whole-stage-codegen on)0.29 secPassed
test single unique condition (equal) for left anti join using BroadcastNestedLoopJoin build left0.13 secPassed
test single unique condition (equal) for left anti join using BroadcastNestedLoopJoin build right (whole-stage-codegen off)99 msPassed
test single unique condition (equal) for left anti join using BroadcastNestedLoopJoin build right (whole-stage-codegen on)0.1 secPassed
test single unique condition (equal) for left anti join using ShuffledHashJoin (whole-stage-codegen off)91 msPassed
test single unique condition (equal) for left anti join using ShuffledHashJoin (whole-stage-codegen on)0.17 secPassed
test single unique condition (equal) for left anti join using SortMergeJoin (whole-stage-codegen off)0.11 secPassed
test single unique condition (equal) for left anti join using SortMergeJoin (whole-stage-codegen on)89 msPassed
test single unique condition (equal) for left semi join using BroadcastHashJoin (whole-stage-codegen off)0.11 secPassed
test single unique condition (equal) for left semi join using BroadcastHashJoin (whole-stage-codegen on)0.14 secPassed
test single unique condition (equal) for left semi join using BroadcastNestedLoopJoin build left0.13 secPassed
test single unique condition (equal) for left semi join using BroadcastNestedLoopJoin build right (whole-stage-codegen off)0.11 secPassed
test single unique condition (equal) for left semi join using BroadcastNestedLoopJoin build right (whole-stage-codegen on)0.1 secPassed
test single unique condition (equal) for left semi join using ShuffledHashJoin (whole-stage-codegen off)0.1 secPassed
test single unique condition (equal) for left semi join using ShuffledHashJoin (whole-stage-codegen on)0.12 secPassed
test single unique condition (equal) for left semi join using SortMergeJoin (whole-stage-codegen off)0.11 secPassed
test single unique condition (equal) for left semi join using SortMergeJoin (whole-stage-codegen on)0.13 secPassed