[ https://issues.apache.org/jira/browse/IMPALA-8959?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Tim Armstrong resolved IMPALA-8959. ----------------------------------- Resolution: Duplicate I'm pretty sure that this the same cause - I checked and the query was run via HS2, so we're exposed to the same Impyla bug. > 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 > Affects Versions: Impala 3.4.0 > 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: issues-all-unsubscr...@impala.apache.org For additional commands, e-mail: issues-all-h...@impala.apache.org