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

test_inline_view_limit fails in exhaustive tests

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Blocker
    • Resolution: Fixed
    • Affects Version/s: Impala 2.11.0
    • Fix Version/s: Impala 2.11.0
    • Component/s: Backend
    • Labels:

      Description

      The failing test was added in this change for IMPALA-4236. I ran the test locally and it passes in core exploration mode, but fails in exhaustive. My local branch was at commit 30629fdea5 IMPALA-2758: Remove BufferedTupleStream::GetRows (2017-10-27 22:15 GMT) <Tianyi Wang>.

      Bikramjeet Vig - Can you have a look?

      Here is the output from running it locally, below is what I saw in a private Jenkins build.

      -- executing against localhost:21000
      select count(*) from (
        select id from
          (select id from functional.alltypes limit 7300) v1
        where id >= 0) v2;
      
      -- executing against localhost:21000
      select * from (select * from alltypes order by id limit 20) t1 where int_col <100 limit 5;
      
      FAILED-- closing connection to: localhost:21000
      
      ====================================== short test summary info =======================================
      FAIL tests/query_test/test_queries.py::TestQueries::()::test_inline_view_limit[exec_option: {'batch_size': 0, 'num_nodes': 0, 'disable_codegen_rows_threshold': 0, 'disable_codegen': True, 'abort_on_error': 1, 'exec_single_node_rows_threshold': 0} | table_format: hbase/none]
      
      ============================================== FAILURES ==============================================
       TestQueries.test_inline_view_limit[exec_option: {'batch_size': 0, 'num_nodes': 0, 'disable_codegen_rows_threshold': 0, 'disable_codegen': True, 'abort_on_error': 1, 'exec_single_node_rows_threshold': 0} | table_format: hbase/none]
      tests/query_test/test_queries.py:108: in test_inline_view_limit
          self.run_test_case('QueryTest/inline-view-limit', vector)
      tests/common/impala_test_suite.py:424: in run_test_case
          self.__verify_results_and_errors(vector, test_section, result, use_db)
      tests/common/impala_test_suite.py:297: in __verify_results_and_errors
          replace_filenames_with_placeholder)
      tests/common/test_result_verifier.py:348: in verify_raw_results
          verify_results(expected_types, actual_types, order_matters=True)
      tests/common/test_result_verifier.py:258: in verify_results
          assert expected_results == actual_results
      E   assert ['INT', 'BOOL...'BIGINT', ...] == ['INT', 'BIGIN... 'FLOAT', ...]
      E     At index 1 diff: 'BOOLEAN' != 'BIGINT'
      E     Full diff:
      E     ['INT',
      E     +  'BIGINT',
      E     'BOOLEAN',
      E     +  'STRING',
      E     +  'DOUBLE',
      E     +  'FLOAT',
      E     -  'TINYINT',
      E     ?   ----
      E     +  'INT',
      E     +  'INT',
      E     'SMALLINT',
      E     -  'INT',
      E     -  'BIGINT',
      E     -  'FLOAT',
      E     -  'DOUBLE',
      E     -  'STRING',
      E     'STRING',
      E     'TIMESTAMP',
      E     -  'INT',
      E     +  'TINYINT',
      E     ?   ++++
      E     'INT']
      !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! Interrupted: stopping after 1 failures !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
      ======================== 2562 tests deselected by '-ktest_inline_view_limit' =========================
      
      14:45:20 -- executing against localhost:21000
      14:45:20 select * from (select * from alltypes order by id limit 20) t1 where int_col <100 limit 5;
      14:45:20 
      14:45:20  TestHdfsQueries.test_inline_view_limit[exec_option: {'disable_codegen_rows_threshold': 0, 'disable_codegen': True, 'abort_on_error': 1, 'exec_single_node_rows_threshold': 100, 'batch_size': 0, 'num_nodes': 0} | table_format: hbase/none] 
      14:45:20 [gw2] linux2 -- Python 2.6.6 /data/jenkins/workspace/impala-asf-master-exhaustive/repos/Impala/bin/../infra/python/env/bin/python
      14:45:20 query_test/test_queries.py:108: in test_inline_view_limit
      14:45:20     self.run_test_case('QueryTest/inline-view-limit', vector)
      14:45:20 common/impala_test_suite.py:424: in run_test_case
      14:45:20     self.__verify_results_and_errors(vector, test_section, result, use_db)
      14:45:20 common/impala_test_suite.py:297: in __verify_results_and_errors
      14:45:20     replace_filenames_with_placeholder)
      14:45:20 common/test_result_verifier.py:348: in verify_raw_results
      14:45:20     verify_results(expected_types, actual_types, order_matters=True)
      14:45:20 common/test_result_verifier.py:258: in verify_results
      14:45:20     assert expected_results == actual_results
      14:45:20 E   assert ['INT', 'BOOL...'BIGINT', ...] == ['INT', 'BIGIN... 'FLOAT', ...]
      14:45:20 E     At index 1 diff: 'BOOLEAN' != 'BIGINT'
      14:45:20 E     Use -v to get the full diff
      

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                bikramjeet.vig Bikramjeet Vig
                Reporter:
                lv Lars Volker
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: