Uploaded image for project: 'IMPALA'
  1. IMPALA
  2. IMPALA-12798

regr_intercept() might have inconsistant results on TIMESTAMP values

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • None
    • Impala 4.4.0
    • Backend
    • None

    Description

      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

      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
      

      Stacktrace

      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
      

      The query is

      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;

      Attachments

        Issue Links

          Activity

            People

              pranav.lodha Pranav Yogi Lodha
              stigahuang Quanlong Huang
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: