Quanlong Huang created IMPALA-12798:
---------------------------------------
Summary: regr_intercept() might have inconsistant results on
TIMESTAMP values
Key: IMPALA-12798
URL: https://issues.apache.org/jira/browse/IMPALA-12798
Project: IMPALA
Issue Type: Bug
Components: Backend
Reporter: Quanlong Huang
Assignee: Pranav Yogi Lodha
Found a test failure with below error messages:
*Test*
query_test.test_aggregation.TestAggregationQueries.test_aggregation[protocol:
beeswax | exec_option: {'test_replan': 1, 'batch_size': 0, 'num_nodes': 0,
'disable_codegen_rows_threshold': 0, 'disable_codegen': False,
'abort_on_error': 1, 'exec_single_node_rows_threshold': 0} | table_format:
seq/def/block]
*Error Message*
{code:java}
query_test/test_aggregation.py:203: in test_aggregation
self.run_test_case('QueryTest/aggregation', vector)
common/impala_test_suite.py:815: in run_test_case
self.__verify_results_and_errors(vector, test_section, result, use_db)
common/impala_test_suite.py:625: in __verify_results_and_errors
replace_filenames_with_placeholder) common/test_result_verifier.py:503: in
verify_raw_results VERIFIER_MAP[verifier](expected, actual)
common/test_result_verifier.py:312: in verify_query_result_is_equal assert
expected_results == actual_results E assert Comparing QueryTestResults
(expected vs actual): E 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0 !=
0,0,0,0,0,0,2.384185791015625e-07
{code}
*Stacktrace*
{code:java}
query_test/test_aggregation.py:203: in test_aggregation
self.run_test_case('QueryTest/aggregation', vector)
common/impala_test_suite.py:815: in run_test_case
self.__verify_results_and_errors(vector, test_section, result, use_db)
common/impala_test_suite.py:625: in __verify_results_and_errors
replace_filenames_with_placeholder)
common/test_result_verifier.py:503: in verify_raw_results
VERIFIER_MAP[verifier](expected, actual)
common/test_result_verifier.py:312: in verify_query_result_is_equal
assert expected_results == actual_results
E assert Comparing QueryTestResults (expected vs actual):
E 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0 != 0,0,0,0,0,0,2.384185791015625e-07
{code}
The query is
{code:sql}
select regr_intercept(tinyint_col, tinyint_col), regr_intercept(smallint_col,
smallint_col),
regr_intercept(int_col, int_col), regr_intercept(bigint_col, bigint_col),
regr_intercept(float_col, float_col),
regr_intercept(double_col, double_col), regr_intercept(timestamp_col,
timestamp_col) from functional.alltypes;{code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
