[
https://issues.apache.org/jira/browse/IMPALA-8959?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Tim Armstrong updated IMPALA-8959:
----------------------------------
Description:
Error details
{noformat}
query_test/test_queries.py:77: in test_union
self.run_test_case('QueryTest/union', vector) common/impala_test_suite.py:611:
in run_test_case self.__verify_results_and_errors(vector, test_section,
result, use_db) common/impala_test_suite.py:448: in __verify_results_and_errors
replace_filenames_with_placeholder) common/test_result_verifier.py:456: in
verify_raw_results VERIFIER_MAP[verifier](expected, actual)
common/test_result_verifier.py:278: in verify_query_result_is_equal assert
expected_results == actual_results E assert Comparing QueryTestResults
(expected vs actual): E 0,true,0,0,0,0,0,0,'01/01/09','0',2009-01-01
00:00:00,2009,1 != None E 0,true,0,0,0,0,0,0,'01/01/09','0',2009-01-01
00:00:00,2009,1 != None E
1,false,1,1,1,10,1.100000023841858,10.1,'01/01/09','1',2009-01-01
00:01:00,2009,1 != None E
1,false,1,1,1,10,1.100000023841858,10.1,'01/01/09','1',2009-01-01
00:01:00,2009,1 != None E 2,true,0,0,0,0,0,0,'02/01/09','0',2009-02-01
00:00:00,2009,2 != None E 2,true,0,0,0,0,0,0,'02/01/09','0',2009-02-01
00:00:00,2009,2 != None E
3,false,1,1,1,10,1.100000023841858,10.1,'02/01/09','1',2009-02-01
00:01:00,2009,2 != None E
3,false,1,1,1,10,1.100000023841858,10.1,'02/01/09','1',2009-02-01
00:01:00,2009,2 != None E 4,true,0,0,0,0,0,0,'03/01/09','0',2009-03-01
00:00:00,2009,3 != None E
5,false,1,1,1,10,1.100000023841858,10.1,'03/01/09','1',2009-03-01
00:01:00,2009,3 != None E Number of rows returned (expected vs actual): 10
!= 0{noformat}
Stack trace
{noformat}
query_test/test_queries.py:77: in test_union
self.run_test_case('QueryTest/union', vector)
common/impala_test_suite.py:611: in run_test_case
self.__verify_results_and_errors(vector, test_section, result, use_db)
common/impala_test_suite.py:448: in __verify_results_and_errors
replace_filenames_with_placeholder)
common/test_result_verifier.py:456: in verify_raw_results
VERIFIER_MAP[verifier](expected, actual)
common/test_result_verifier.py:278: in verify_query_result_is_equal
assert expected_results == actual_results
E assert Comparing QueryTestResults (expected vs actual):
E 0,true,0,0,0,0,0,0,'01/01/09','0',2009-01-01 00:00:00,2009,1 != None
E 0,true,0,0,0,0,0,0,'01/01/09','0',2009-01-01 00:00:00,2009,1 != None
E 1,false,1,1,1,10,1.100000023841858,10.1,'01/01/09','1',2009-01-01
00:01:00,2009,1 != None
E 1,false,1,1,1,10,1.100000023841858,10.1,'01/01/09','1',2009-01-01
00:01:00,2009,1 != None
E 2,true,0,0,0,0,0,0,'02/01/09','0',2009-02-01 00:00:00,2009,2 != None
E 2,true,0,0,0,0,0,0,'02/01/09','0',2009-02-01 00:00:00,2009,2 != None
E 3,false,1,1,1,10,1.100000023841858,10.1,'02/01/09','1',2009-02-01
00:01:00,2009,2 != None
E 3,false,1,1,1,10,1.100000023841858,10.1,'02/01/09','1',2009-02-01
00:01:00,2009,2 != None
E 4,true,0,0,0,0,0,0,'03/01/09','0',2009-03-01 00:00:00,2009,3 != None
E 5,false,1,1,1,10,1.100000023841858,10.1,'03/01/09','1',2009-03-01
00:01:00,2009,3 != None
E Number of rows returned (expected vs actual): 10 != 0{noformat}
{noformat}
select id, bool_col, tinyint_col, smallint_col, int_col, bigint_col, float_col,
double_col, date_string_col, string_col, timestamp_col, year, month from
alltypestiny where year=2009 and month=1
union all
(select id, bool_col, tinyint_col, smallint_col, int_col, bigint_col,
float_col, double_col, date_string_col, string_col, timestamp_col, year, month
from alltypestiny where year=2009 and month=1
union all
(select id, bool_col, tinyint_col, smallint_col, int_col, bigint_col,
float_col, double_col, date_string_col, string_col, timestamp_col, year, month
from alltypestiny where year=2009 and month=2
union all
(select id, bool_col, tinyint_col, smallint_col, int_col, bigint_col,
float_col, double_col, date_string_col, string_col, timestamp_col, year, month
from alltypestiny where year=2009 and month=2
union all
select id, bool_col, tinyint_col, smallint_col, int_col, bigint_col,
float_col, double_col, date_string_col, string_col, timestamp_col, year, month
from alltypestiny where year=2009 and month=3)));
-- getting log for operation: <tests.common.impala_connection.OperationHandle
object at 0x64faad0>
-- getting runtime profile operation:
<tests.common.impala_connection.OperationHandle object at 0x64faad0>
-- closing query for operation handle:
<tests.common.impala_connection.OperationHandle object at 0x64faad0>
-- 2019-09-16 11:02:10,810 INFO MainThread: Closing active operation
-- 2019-09-16 11:02:10,844 ERROR MainThread: Comparing QueryTestResults
(expected vs actual):
0,true,0,0,0,0,0,0,'01/01/09','0',2009-01-01 00:00:00,2009,1 != None
0,true,0,0,0,0,0,0,'01/01/09','0',2009-01-01 00:00:00,2009,1 != None
1,false,1,1,1,10,1.100000023841858,10.1,'01/01/09','1',2009-01-01
00:01:00,2009,1 != None
1,false,1,1,1,10,1.100000023841858,10.1,'01/01/09','1',2009-01-01
00:01:00,2009,1 != None
2,true,0,0,0,0,0,0,'02/01/09','0',2009-02-01 00:00:00,2009,2 != None
2,true,0,0,0,0,0,0,'02/01/09','0',2009-02-01 00:00:00,2009,2 != None
3,false,1,1,1,10,1.100000023841858,10.1,'02/01/09','1',2009-02-01
00:01:00,2009,2 != None
3,false,1,1,1,10,1.100000023841858,10.1,'02/01/09','1',2009-02-01
00:01:00,2009,2 != None
4,true,0,0,0,0,0,0,'03/01/09','0',2009-03-01 00:00:00,2009,3 != None
5,false,1,1,1,10,1.100000023841858,10.1,'03/01/09','1',2009-03-01
00:01:00,2009,3 != None
Number of rows returned (expected vs actual): 10 != 0
{noformat}
was:
Error details
{noformat}
query_test/test_queries.py:77: in test_union
self.run_test_case('QueryTest/union', vector) common/impala_test_suite.py:611:
in run_test_case self.__verify_results_and_errors(vector, test_section,
result, use_db) common/impala_test_suite.py:448: in __verify_results_and_errors
replace_filenames_with_placeholder) common/test_result_verifier.py:456: in
verify_raw_results VERIFIER_MAP[verifier](expected, actual)
common/test_result_verifier.py:278: in verify_query_result_is_equal assert
expected_results == actual_results E assert Comparing QueryTestResults
(expected vs actual): E 0,true,0,0,0,0,0,0,'01/01/09','0',2009-01-01
00:00:00,2009,1 != None E 0,true,0,0,0,0,0,0,'01/01/09','0',2009-01-01
00:00:00,2009,1 != None E
1,false,1,1,1,10,1.100000023841858,10.1,'01/01/09','1',2009-01-01
00:01:00,2009,1 != None E
1,false,1,1,1,10,1.100000023841858,10.1,'01/01/09','1',2009-01-01
00:01:00,2009,1 != None E 2,true,0,0,0,0,0,0,'02/01/09','0',2009-02-01
00:00:00,2009,2 != None E 2,true,0,0,0,0,0,0,'02/01/09','0',2009-02-01
00:00:00,2009,2 != None E
3,false,1,1,1,10,1.100000023841858,10.1,'02/01/09','1',2009-02-01
00:01:00,2009,2 != None E
3,false,1,1,1,10,1.100000023841858,10.1,'02/01/09','1',2009-02-01
00:01:00,2009,2 != None E 4,true,0,0,0,0,0,0,'03/01/09','0',2009-03-01
00:00:00,2009,3 != None E
5,false,1,1,1,10,1.100000023841858,10.1,'03/01/09','1',2009-03-01
00:01:00,2009,3 != None E Number of rows returned (expected vs actual): 10
!= 0{noformat}
Stack trace
{noformat}
query_test/test_queries.py:77: in test_union
self.run_test_case('QueryTest/union', vector)
common/impala_test_suite.py:611: in run_test_case
self.__verify_results_and_errors(vector, test_section, result, use_db)
common/impala_test_suite.py:448: in __verify_results_and_errors
replace_filenames_with_placeholder)
common/test_result_verifier.py:456: in verify_raw_results
VERIFIER_MAP[verifier](expected, actual)
common/test_result_verifier.py:278: in verify_query_result_is_equal
assert expected_results == actual_results
E assert Comparing QueryTestResults (expected vs actual):
E 0,true,0,0,0,0,0,0,'01/01/09','0',2009-01-01 00:00:00,2009,1 != None
E 0,true,0,0,0,0,0,0,'01/01/09','0',2009-01-01 00:00:00,2009,1 != None
E 1,false,1,1,1,10,1.100000023841858,10.1,'01/01/09','1',2009-01-01
00:01:00,2009,1 != None
E 1,false,1,1,1,10,1.100000023841858,10.1,'01/01/09','1',2009-01-01
00:01:00,2009,1 != None
E 2,true,0,0,0,0,0,0,'02/01/09','0',2009-02-01 00:00:00,2009,2 != None
E 2,true,0,0,0,0,0,0,'02/01/09','0',2009-02-01 00:00:00,2009,2 != None
E 3,false,1,1,1,10,1.100000023841858,10.1,'02/01/09','1',2009-02-01
00:01:00,2009,2 != None
E 3,false,1,1,1,10,1.100000023841858,10.1,'02/01/09','1',2009-02-01
00:01:00,2009,2 != None
E 4,true,0,0,0,0,0,0,'03/01/09','0',2009-03-01 00:00:00,2009,3 != None
E 5,false,1,1,1,10,1.100000023841858,10.1,'03/01/09','1',2009-03-01
00:01:00,2009,3 != None
E Number of rows returned (expected vs actual): 10 != 0{noformat}
> test_union failed with wrong results on S3
> ------------------------------------------
>
> Key: IMPALA-8959
> URL: https://issues.apache.org/jira/browse/IMPALA-8959
> Project: IMPALA
> Issue Type: Bug
> Reporter: Zoltán Borók-Nagy
> Assignee: Tim Armstrong
> Priority: Blocker
> Labels: broken-build, flaky
>
> Error details
> {noformat}
> query_test/test_queries.py:77: in test_union
> self.run_test_case('QueryTest/union', vector)
> common/impala_test_suite.py:611: in run_test_case
> self.__verify_results_and_errors(vector, test_section, result, use_db)
> common/impala_test_suite.py:448: in __verify_results_and_errors
> replace_filenames_with_placeholder) common/test_result_verifier.py:456: in
> verify_raw_results VERIFIER_MAP[verifier](expected, actual)
> common/test_result_verifier.py:278: in verify_query_result_is_equal
> assert expected_results == actual_results E assert Comparing
> QueryTestResults (expected vs actual): E
> 0,true,0,0,0,0,0,0,'01/01/09','0',2009-01-01 00:00:00,2009,1 != None E
> 0,true,0,0,0,0,0,0,'01/01/09','0',2009-01-01 00:00:00,2009,1 != None E
> 1,false,1,1,1,10,1.100000023841858,10.1,'01/01/09','1',2009-01-01
> 00:01:00,2009,1 != None E
> 1,false,1,1,1,10,1.100000023841858,10.1,'01/01/09','1',2009-01-01
> 00:01:00,2009,1 != None E 2,true,0,0,0,0,0,0,'02/01/09','0',2009-02-01
> 00:00:00,2009,2 != None E 2,true,0,0,0,0,0,0,'02/01/09','0',2009-02-01
> 00:00:00,2009,2 != None E
> 3,false,1,1,1,10,1.100000023841858,10.1,'02/01/09','1',2009-02-01
> 00:01:00,2009,2 != None E
> 3,false,1,1,1,10,1.100000023841858,10.1,'02/01/09','1',2009-02-01
> 00:01:00,2009,2 != None E 4,true,0,0,0,0,0,0,'03/01/09','0',2009-03-01
> 00:00:00,2009,3 != None E
> 5,false,1,1,1,10,1.100000023841858,10.1,'03/01/09','1',2009-03-01
> 00:01:00,2009,3 != None E Number of rows returned (expected vs actual):
> 10 != 0{noformat}
> Stack trace
> {noformat}
> query_test/test_queries.py:77: in test_union
> self.run_test_case('QueryTest/union', vector)
> common/impala_test_suite.py:611: in run_test_case
> self.__verify_results_and_errors(vector, test_section, result, use_db)
> common/impala_test_suite.py:448: in __verify_results_and_errors
> replace_filenames_with_placeholder)
> common/test_result_verifier.py:456: in verify_raw_results
> VERIFIER_MAP[verifier](expected, actual)
> common/test_result_verifier.py:278: in verify_query_result_is_equal
> assert expected_results == actual_results
> E assert Comparing QueryTestResults (expected vs actual):
> E 0,true,0,0,0,0,0,0,'01/01/09','0',2009-01-01 00:00:00,2009,1 != None
> E 0,true,0,0,0,0,0,0,'01/01/09','0',2009-01-01 00:00:00,2009,1 != None
> E 1,false,1,1,1,10,1.100000023841858,10.1,'01/01/09','1',2009-01-01
> 00:01:00,2009,1 != None
> E 1,false,1,1,1,10,1.100000023841858,10.1,'01/01/09','1',2009-01-01
> 00:01:00,2009,1 != None
> E 2,true,0,0,0,0,0,0,'02/01/09','0',2009-02-01 00:00:00,2009,2 != None
> E 2,true,0,0,0,0,0,0,'02/01/09','0',2009-02-01 00:00:00,2009,2 != None
> E 3,false,1,1,1,10,1.100000023841858,10.1,'02/01/09','1',2009-02-01
> 00:01:00,2009,2 != None
> E 3,false,1,1,1,10,1.100000023841858,10.1,'02/01/09','1',2009-02-01
> 00:01:00,2009,2 != None
> E 4,true,0,0,0,0,0,0,'03/01/09','0',2009-03-01 00:00:00,2009,3 != None
> E 5,false,1,1,1,10,1.100000023841858,10.1,'03/01/09','1',2009-03-01
> 00:01:00,2009,3 != None
> E Number of rows returned (expected vs actual): 10 != 0{noformat}
> {noformat}
> select id, bool_col, tinyint_col, smallint_col, int_col, bigint_col,
> float_col, double_col, date_string_col, string_col, timestamp_col, year,
> month from alltypestiny where year=2009 and month=1
> union all
> (select id, bool_col, tinyint_col, smallint_col, int_col, bigint_col,
> float_col, double_col, date_string_col, string_col, timestamp_col, year,
> month from alltypestiny where year=2009 and month=1
> union all
> (select id, bool_col, tinyint_col, smallint_col, int_col, bigint_col,
> float_col, double_col, date_string_col, string_col, timestamp_col, year,
> month from alltypestiny where year=2009 and month=2
> union all
> (select id, bool_col, tinyint_col, smallint_col, int_col, bigint_col,
> float_col, double_col, date_string_col, string_col, timestamp_col, year,
> month from alltypestiny where year=2009 and month=2
> union all
> select id, bool_col, tinyint_col, smallint_col, int_col, bigint_col,
> float_col, double_col, date_string_col, string_col, timestamp_col, year,
> month from alltypestiny where year=2009 and month=3)));
> -- getting log for operation: <tests.common.impala_connection.OperationHandle
> object at 0x64faad0>
> -- getting runtime profile operation:
> <tests.common.impala_connection.OperationHandle object at 0x64faad0>
> -- closing query for operation handle:
> <tests.common.impala_connection.OperationHandle object at 0x64faad0>
> -- 2019-09-16 11:02:10,810 INFO MainThread: Closing active operation
> -- 2019-09-16 11:02:10,844 ERROR MainThread: Comparing QueryTestResults
> (expected vs actual):
> 0,true,0,0,0,0,0,0,'01/01/09','0',2009-01-01 00:00:00,2009,1 != None
> 0,true,0,0,0,0,0,0,'01/01/09','0',2009-01-01 00:00:00,2009,1 != None
> 1,false,1,1,1,10,1.100000023841858,10.1,'01/01/09','1',2009-01-01
> 00:01:00,2009,1 != None
> 1,false,1,1,1,10,1.100000023841858,10.1,'01/01/09','1',2009-01-01
> 00:01:00,2009,1 != None
> 2,true,0,0,0,0,0,0,'02/01/09','0',2009-02-01 00:00:00,2009,2 != None
> 2,true,0,0,0,0,0,0,'02/01/09','0',2009-02-01 00:00:00,2009,2 != None
> 3,false,1,1,1,10,1.100000023841858,10.1,'02/01/09','1',2009-02-01
> 00:01:00,2009,2 != None
> 3,false,1,1,1,10,1.100000023841858,10.1,'02/01/09','1',2009-02-01
> 00:01:00,2009,2 != None
> 4,true,0,0,0,0,0,0,'03/01/09','0',2009-03-01 00:00:00,2009,3 != None
> 5,false,1,1,1,10,1.100000023841858,10.1,'03/01/09','1',2009-03-01
> 00:01:00,2009,3 != None
> Number of rows returned (expected vs actual): 10 != 0
> {noformat}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
