[IMPALA-10821] TestTPCHJoinQueries.test_outer_joins failed in s3 build

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: Impala 4.1.0
• Fix Version/s: Impala 4.1.0
• Component/s: Backend
• Labels: broken-build
• Epic Color: ghx-label-3
• Assignee: Yida Wu
• Reporter: Wenzhe Zhou
• Created: 22/Jul/21 19:21
• Updated: 03/Dec/21 05:38
• Resolved: 09/Aug/21 23:40

Description

The unit-test TestTPCHJoinQueries.test_outer_joins failed in following build:

https://master-03.jenkins.cloudera.com/job/impala-asf-master-core-s3/63/

 

The failed test case was added recently by patch: https://gerrit.cloudera.org/#/c/17610/

Error Message
query_test/test_join_queries.py:155: in test_outer_joins self.run_test_case('tpch-outer-joins', new_vector) common/impala_test_suite.py:709: in run_test_case self.__verify_results_and_errors(vector, test_section, result, use_db) common/impala_test_suite.py:545: in __verify_results_and_errors replace_filenames_with_placeholder) common/test_result_verifier.py:469: in verify_raw_results VERIFIER_MAP[verifier](expected, actual) common/test_result_verifier.py:246: in verify_query_result_is_subset assert expected_literal_strings <= actual_literal_strings E assert Items in expected results not found in actual results: E '| 00:SCAN HDFS [default.t1 b]' E '01:SCAN HDFS [default.t2 a]' E Items in actual results: E '05:EXCHANGE [UNPARTITIONED]' E '|-04:EXCHANGE [HASH(b.`INSERT`,b.`insert`)]' E '| |' E ' runtime filters: RF000 -> a.`SELECT`, RF001 -> a.`select`' E 'PLAN-ROOT SINK' E '' E '02:HASH JOIN [RIGHT OUTER JOIN, PARTITIONED]' E 'default.t1, default.t2' E '| row-size=8B cardinality=37' E '03:EXCHANGE [HASH(a.`SELECT`,a.`select`)]' E '|' E '| row-size=16B cardinality=37' E ' row-size=8B cardinality=78.25K' E '| hash predicates: a.`SELECT` = b.`INSERT`, a.`select` = b.`insert`' E 'WARNING: The following tables are missing relevant table and/or column statistics.' E '| runtime filters: RF000 < b.`INSERT`, RF001 <- b.`insert`' E '| S3 partitions=1/1 files=1 size=292B' E '| 00:SCAN S3 [default.t1 b]' E 'Per-Host Resource Estimates: Memory=75MB' E '01:SCAN S3 [default.t2 a]' E ' S3 partitions=1/1 files=1 size=611.34KB' E 'Max Per-Host Resource Reservation: Memory=10.95MB Threads=6'

Stacktrace
query_test/test_join_queries.py:155: in test_outer_joins
self.run_test_case('tpch-outer-joins', new_vector)
common/impala_test_suite.py:709: in run_test_case
self.__verify_results_and_errors(vector, test_section, result, use_db)
common/impala_test_suite.py:545: in __verify_results_and_errors
replace_filenames_with_placeholder)
common/test_result_verifier.py:469: in verify_raw_results
VERIFIER_MAP[verifier](expected, actual)
common/test_result_verifier.py:246: in verify_query_result_is_subset
assert expected_literal_strings <= actual_literal_strings
E assert Items in expected results not found in actual results:
E '| 00:SCAN HDFS [default.t1 b]'
E '01:SCAN HDFS [default.t2 a]'
E Items in actual results:
E '05:EXCHANGE [UNPARTITIONED]'
E '|--04:EXCHANGE [HASH(b.`INSERT`,b.`insert`)]'
E '| |'
E ' runtime filters: RF000 -> a.`SELECT`, RF001 -> a.`select`'
E 'PLAN-ROOT SINK'
E ''
E '02:HASH JOIN [RIGHT OUTER JOIN, PARTITIONED]'
E 'default.t1, default.t2'
E '| row-size=8B cardinality=37'
E '03:EXCHANGE [HASH(a.`SELECT`,a.`select`)]'
E '|'
E '| row-size=16B cardinality=37'
E ' row-size=8B cardinality=78.25K'
E '| hash predicates: a.`SELECT` = b.`INSERT`, a.`select` = b.`insert`'
E 'WARNING: The following tables are missing relevant table and/or column statistics.'
E '| runtime filters: RF000 <- b.`INSERT`, RF001 <- b.`insert`'
E '| S3 partitions=1/1 files=1 size=292B'
E '| 00:SCAN S3 [default.t1 b]'
E 'Per-Host Resource Estimates: Memory=75MB'
E '01:SCAN S3 [default.t2 a]'
E ' S3 partitions=1/1 files=1 size=611.34KB'
E 'Max Per-Host Resource Reservation: Memory=10.95MB Threads=6'