You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues-all@impala.apache.org by "ASF subversion and git services (Jira)" <ji...@apache.org> on 2021/07/27 01:01:16 UTC
[jira] [Commented] (IMPALA-10821)
TestTPCHJoinQueries.test_outer_joins failed in s3 build
[ https://issues.apache.org/jira/browse/IMPALA-10821?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17387661#comment-17387661 ]
ASF subversion and git services commented on IMPALA-10821:
----------------------------------------------------------
Commit 46f13437db2d64d9ee431c2c5cf424be3b8d6377 in impala's branch refs/heads/master from Yida Wu
[ https://gitbox.apache.org/repos/asf?p=impala.git;h=46f1343 ]
IMPALA-10821 Fix TestTPCHJoinQueries.test_outer_joins failed
A new added testcase in TestTPCHJoinQueries.test_outer_joins
can't pass the s3 build because the plan generated in s3 build
is not the same as the default hdfs build for the scan node. In
s3 build, it is "SCAN S3", while in hdfs build, it is "SCAN HDFS".
The patch changed the testcase to use $FILESYSTEM_NAME, which
will be changed according to the file system the testcase is
using.
Tests:
Reran and passed the failed testcase in s3 build.
Change-Id: I7e068d9da03517f8316e7a2505ce1466523d5917
Reviewed-on: http://gerrit.cloudera.org:8080/17716
Reviewed-by: Impala Public Jenkins <im...@cloudera.com>
Tested-by: Impala Public Jenkins <im...@cloudera.com>
> TestTPCHJoinQueries.test_outer_joins failed in s3 build
> -------------------------------------------------------
>
> 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
> Priority: Major
> Labels: broken-build
>
> 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)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-all-unsubscribe@impala.apache.org
For additional commands, e-mail: issues-all-help@impala.apache.org