[
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: [email protected]
For additional commands, e-mail: [email protected]
