[IMPALA-13323] Remove redundant tests in test_join_queries.py

• Type: Improvement
• Status: Resolved
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: Impala 4.4.0
• Fix Version/s: Impala 4.5.0
• Component/s: Test
• Target Version: Impala 4.5.0
• Epic Color: ghx-label-13
• Assignee: Riza Suminto
• Reporter: Riza Suminto
• Created: 23/Aug/24 05:12
• Updated: 05/Sep/24 21:28
• Resolved: 26/Aug/24 20:09

Description

test_join_queries.py is expensive to run in exhaustive exploration because it run many test dimension permutation, but actually never exercise some of the dimensions. Those redundant tests are follows:

• Have mt_dop dimension, but not exercising it:
  test_outer_to_inner_joins
  test_single_node_nested_loop_joins
• Have batch_size dimension but not exercising it:
  test_outer_to_inner_joins
  test_single_node_nested_loop_joins
  test_single_node_nested_loop_joins_exhaustive
  test_semi_joins_exhaustive
• Have enable_outer_join_to_inner_transformation dimension but not exercising it:
  All TestJoinQueries except test_outer_to_inner_joins

test_miss_tuple_joins is also valid to run with much fewer test dimension because it mainly test correctness of predicate pushdown during planning.