[IMPALA-2329] Wrong results in test_single_node_nested_loop_joins with the old aggs/joins

• Type: Bug
• Status: Resolved
• Priority: Blocker
• Resolution: Duplicate
• Affects Version/s: Impala 2.3.0
• Labels: broken-build correctness
• Target Version: Impala 2.3.0
• Assignee: Tim Armstrong
• Reporter: Ippokratis Pandis
• Created: 12/Sep/15 09:11
• Updated: 14/Sep/15 18:15
• Resolved: 14/Sep/15 18:15

Description

Since we are not going to remove the old aggs/joins from 2.3 we need to make sure that they operate correctly. It seems that one of the recent changes resulted in wrong results.

I offer a cookie to whomever fixes me. See <http://sandbox.jenkins.cloudera.com/job/impala-master-cdh5-trunk-non-partitioned-hash-and-aggs/96/>

FAILED TESTS
================================================
1 tests failed.
REGRESSION: query_test.test_join_queries.TestJoinQueries.test_single_node_nested_loop_joins[batch_size: 0 | exec_option:

{'disable_codegen': False, 'abort_on_error': 1, 'exec_single_node_rows_threshold': 0, 'batch_size': 0, 'num_nodes': 0}

| table_format: parquet/none]

Error Message:
query_test/test_join_queries.py:55: in test_single_node_nested_loop_joins self.run_test_case('QueryTest/single-node-nlj', new_vector) common/impala_test_suite.py:234: in run_test_case pytest.config.option.update_results) common/test_result_verifier.py:345: in verify_raw_results VERIFIER_MAP[verifier](expected, actual) common/test_result_verifier.py:197: in verify_query_result_is_equal assert expected_results == actual_results E assert Comparing QueryTestResults (expected vs actual): E 1,1 != 1,-757446001202478830 E 1,1 != 1,-7925555781794536384 E 1,1 != 1,2673577798038412940 E 1,1 != 1,6162543018722714984 E 1,1 != 1,7349705297469022842

Stack Trace:
query_test/test_join_queries.py:55: in test_single_node_nested_loop_joins
self.run_test_case('QueryTest/single-node-nlj', new_vector)
common/impala_test_suite.py:234: in run_test_case
pytest.config.option.update_results)
common/test_result_verifier.py:345: in verify_raw_results
VERIFIER_MAP[verifier](expected, actual)
common/test_result_verifier.py:197: in verify_query_result_is_equal
assert expected_results == actual_results
E assert Comparing QueryTestResults (expected vs actual):
E 1,1 != 1,-757446001202478830
E 1,1 != 1,-7925555781794536384
E 1,1 != 1,2673577798038412940
E 1,1 != 1,6162543018722714984
E 1,1 != 1,7349705297469022842

Issue Links

• duplicates: IMPALA-2332 TestJoinQueries.test_single_node_nested_loop_joins failure