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

query_test.test_queries.TestQueriesTextTables.test_strict_mode fails on SLES12 SP2

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Blocker
    • Resolution: Cannot Reproduce
    • Impala 2.9.0
    • Impala 2.9.0
    • None
    • None
    • ghx-label-9

    Description

      This runs successfully on Ubuntu, Centos, Redhat, Debian, and Oracle. However, it fails on SLES12 with the following error:

      Stacktrace:

      query_test/test_queries.py:150: in test_strict_mode
          self.run_test_case('QueryTest/strict-mode', vector)
      common/impala_test_suite.py:388: in run_test_case
          self.__verify_results_and_errors(vector, test_section, result, use_db)
      common/impala_test_suite.py:273: in __verify_results_and_errors
          replace_filenames_with_placeholder)
      common/test_result_verifier.py:317: in verify_raw_results
          verify_errors(expected_errors, actual_errors)
      common/test_result_verifier.py:274: in verify_errors
          VERIFIER_MAP['VERIFY_IS_EQUAL'](expected, actual)
      common/test_result_verifier.py:231: in verify_query_result_is_equal
          assert expected_results == actual_results
      E   assert Comparing QueryTestResults (expected vs actual):
      E     'Error converting column: 0 to TINYINT' == 'Error converting column: 0 to TINYINT'
      E     'Error converting column: 0 to TINYINT' == 'Error converting column: 0 to TINYINT'
      E     'Error converting column: 1 to SMALLINT' == 'Error converting column: 1 to SMALLINT'
      E     'Error converting column: 1 to SMALLINT' == 'Error converting column: 1 to SMALLINT'
      E     'Error converting column: 2 to INT' == 'Error converting column: 2 to INT'
      E     'Error converting column: 2 to INT' == 'Error converting column: 2 to INT'
      E     'Error converting column: 3 to BIGINT' == 'Error converting column: 3 to BIGINT'
      E     'Error converting column: 3 to BIGINT' == 'Error converting column: 3 to BIGINT'
      E     'Error converting column: 4 to FLOAT' == 'Error converting column: 4 to FLOAT'
      E     'Error converting column: 4 to FLOAT' == 'Error converting column: 4 to FLOAT'
      E     'Error converting column: 5 to DOUBLE' == 'Error converting column: 5 to DOUBLE'
      E     'Error converting column: 5 to DOUBLE' == 'Error converting column: 5 to DOUBLE'
      E     'Error converting column: 6 to DECIMAL(13,4)' != 'Error parsing row: file: hdfs://impala-sles12sp2-test-cluster-1.vpc.cloudera.com:8020/test-warehouse/overflow/overflow.txt, before offset: 160'
      E     'Error converting column: 6 to DECIMAL(13,4)' != 'Error parsing row: file: hdfs://impala-sles12sp2-test-cluster-1.vpc.cloudera.com:8020/test-warehouse/overflow/overflow.txt, before offset: 160'
      E     'Error converting column: 7 to DECIMAL(38,0)' != None
      E     'Error converting column: 7 to DECIMAL(38,0)' != None
      E     'Error converting column: 8 to DECIMAL(38,38)' != None
      E     'Error converting column: 8 to DECIMAL(38,38)' != None
      E     row_regex: .*Error parsing row: file: hdfs://impala-sles12sp2-test-cluster-1.vpc.cloudera.com:8020/.* before offset: \d+ != None
      E     row_regex: .*Error parsing row: file: hdfs://impala-sles12sp2-test-cluster-1.vpc.cloudera.com:8020/.* before offset: \d+ != None
      E     Number of rows returned (expected vs actual): 20 != 14
      

      Attachments

        Activity

          People

            Unassigned Unassigned
            dknupp David Knupp
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: