Uploaded image for project: 'IMPALA'
  1. IMPALA
  2. IMPALA-10821

TestTPCHJoinQueries.test_outer_joins failed in s3 build

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: Impala 4.1.0
    • Fix Version/s: None
    • Component/s: Backend
    • Labels:
    • Epic Color:
      ghx-label-3

      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'

        Attachments

          Activity

            People

            • Assignee:
              baggio000 Yida Wu
              Reporter:
              wzhou Wenzhe Zhou
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: