Details
-
Bug
-
Status: Resolved
-
Critical
-
Resolution: Cannot Reproduce
-
Impala 3.1.0
-
None
-
None
-
ghx-label-5
Description
Seen in a build:
08:09:43 TestQueries.test_analytic_fns[exec_option: {'disable_codegen_rows_threshold': 0, 'disable_codegen': True, 'abort_on_error': 1, 'debug_action': None, 'exec_single_node_rows_threshold': '100', 'batch_size': 0, 'num_nodes': 0} | table_format: text/lzo/block]
08:09:43 [gw1] linux2 -- Python 2.7.5 /data/jenkins/workspace/impala-cdh6.x-exhaustive-release/repos/Impala/bin/../infra/python/env/bin/python
08:09:43 query_test/test_queries.py:54: in test_analytic_fns
08:09:43 self.run_test_case('QueryTest/analytic-fns', vector)
08:09:43 common/impala_test_suite.py:437: in run_test_case
08:09:43 self.__verify_results_and_errors(vector, test_section, result, use_db)
08:09:43 common/impala_test_suite.py:310: in __verify_results_and_errors
08:09:43 replace_filenames_with_placeholder)
08:09:43 common/test_result_verifier.py:433: in verify_raw_results
08:09:43 VERIFIER_MAP[verifier](expected, actual)
08:09:43 common/test_result_verifier.py:260: in verify_query_result_is_equal
08:09:43 assert expected_results == actual_results
08:09:43 E assert Comparing QueryTestResults (expected vs actual):
08:09:43 E 'a\x00b','' != '9k\x00',''
08:09:43 E 'a\x00b','NULL' == 'a\x00b','NULL'
08:09:43 ----------------------------- Captured stderr call -----------------------------
...
08:09:43 -- 2018-09-12 06:49:31,694 INFO MainThread: Started query d14c894f7e2a20fc:c797406b00000000
08:09:43 -- executing against localhost:21000
08:09:43 select count(*) from (
08:09:43 select
08:09:43 from_unixtime(lead(bigint_col, 1) over (order by id), 'yyyyMMddHH:mm:ss') as a,
08:09:43 lead(from_unixtime(bigint_col, 'yyyyMMddHH:mm:ss'), 1) over (order by id) AS b
08:09:43 from functional.alltypes) x
08:09:43 where x.a = x.b;
08:09:43
08:09:43 -- 2018-09-12 06:49:31,809 INFO MainThread: Started query d948840775a29d70:5fce58f400000000
08:09:43 -- executing against localhost:21000
08:09:43 select count(*) from (
08:09:43 select
08:09:43 from_unixtime(lag(bigint_col, 1) over (order by id), 'yyyyMMddHH:mm:ss') as a,
08:09:43 lag(from_unixtime(bigint_col, 'yyyyMMddHH:mm:ss'), 1) over (order by id) AS b
08:09:43 from functional.alltypes) x
08:09:43 where x.a = x.b;
08:09:43
08:09:43 -- 2018-09-12 06:49:31,930 INFO MainThread: Started query 7468c485800eb48:8c6f135600000000
08:09:43 -- executing against localhost:21000
08:09:43 select f,lead(b,1,null) over (order by f)
08:09:43 from (select * from nulltable union all select * from nulltable) x;
08:09:43
08:09:43 -- 2018-09-12 06:49:32,178 INFO MainThread: Started query 3f4a69557cbfc76b:bf6a1a5800000000
08:09:43 -- 2018-09-12 06:49:32,260 ERROR MainThread: Comparing QueryTestResults (expected vs actual):
08:09:43 'a\x00b','' != '9k\x00',''
08:09:43 'a\x00b','NULL' == 'a\x00b','NULL'