[jira] [Created] (IMPALA-10821) TestTPCHJoinQueries.test_outer_joins failed

["Wenzhe Zhou (Jira)" <ji...@apache.org>]

Wenzhe Zhou created IMPALA-10821:
------------------------------------

             Summary: TestTPCHJoinQueries.test_outer_joins failed
                 Key: IMPALA-10821
                 URL: https://issues.apache.org/jira/browse/IMPALA-10821
             Project: IMPALA
          Issue Type: Bug
          Components: Backend
    Affects Versions: Impala 4.1
            Reporter: Wenzhe Zhou
            Assignee: Yida Wu


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'



--
This message was sent by Atlassian Jira
(v8.3.4#803005)