[IMPALA-7371] TestInsertQueries.test_insert fails on S3 with 0 rows returned

• Type: Bug
• Status: Resolved
• Priority: Critical
• Resolution: Cannot Reproduce
• Affects Version/s: Impala 3.0
• Component/s: Catalog
• Target Version: Impala 4.0.0
• Epic Color: ghx-label-6
• Assignee: Bharath Vissapragada
• Reporter: David Knupp
• Created: 31/Jul/18 17:21
• Updated: 19/May/20 20:08
• Resolved: 19/May/20 20:08

Description

Stacktrace

query_test/test_insert.py:118: in test_insert
    multiple_impalad=vector.get_value('exec_option')['sync_ddl'] == 1)
/data/jenkins/workspace/impala-cdh6.0.x-core-s3/repos/Impala/tests/common/impala_test_suite.py:426: in run_test_case
    self.__verify_results_and_errors(vector, test_section, result, use_db)
/data/jenkins/workspace/impala-cdh6.0.x-core-s3/repos/Impala/tests/common/impala_test_suite.py:299: in __verify_results_and_errors
    replace_filenames_with_placeholder)
/data/jenkins/workspace/impala-cdh6.0.x-core-s3/repos/Impala/tests/common/test_result_verifier.py:434: in verify_raw_results
    VERIFIER_MAP[verifier](expected, actual)
/data/jenkins/workspace/impala-cdh6.0.x-core-s3/repos/Impala/tests/common/test_result_verifier.py:261: in verify_query_result_is_equal
    assert expected_results == actual_results
E   assert Comparing QueryTestResults (expected vs actual):
E     75,false,0,0,0,0,0,0,'04/01/09','0' != None
E     76,true,1,1,1,10,1.100000023841858,10.1,'04/01/09','1' != None
E     77,false,2,2,2,20,2.200000047683716,20.2,'04/01/09','2' != None
E     78,true,3,3,3,30,3.299999952316284,30.3,'04/01/09','3' != None
E     79,false,4,4,4,40,4.400000095367432,40.4,'04/01/09','4' != None
E     80,true,5,5,5,50,5.5,50.5,'04/01/09','5' != None
E     81,false,6,6,6,60,6.599999904632568,60.6,'04/01/09','6' != None
E     82,true,7,7,7,70,7.699999809265137,70.7,'04/01/09','7' != None
E     83,false,8,8,8,80,8.800000190734863,80.8,'04/01/09','8' != None
E     84,true,9,9,9,90,9.899999618530273,90.90000000000001,'04/01/09','9' != None
E     85,false,0,0,0,0,0,0,'04/02/09','0' != None
E     86,true,1,1,1,10,1.100000023841858,10.1,'04/02/09','1' != None
E     87,false,2,2,2,20,2.200000047683716,20.2,'04/02/09','2' != None
E     88,true,3,3,3,30,3.299999952316284,30.3,'04/02/09','3' != None
E     89,false,4,4,4,40,4.400000095367432,40.4,'04/02/09','4' != None
E     90,true,5,5,5,50,5.5,50.5,'04/02/09','5' != None
E     91,false,6,6,6,60,6.599999904632568,60.6,'04/02/09','6' != None
E     92,true,7,7,7,70,7.699999809265137,70.7,'04/02/09','7' != None
E     93,false,8,8,8,80,8.800000190734863,80.8,'04/02/09','8' != None
E     94,true,9,9,9,90,9.899999618530273,90.90000000000001,'04/02/09','9' != None
E     95,false,0,0,0,0,0,0,'04/03/09','0' != None
E     96,true,1,1,1,10,1.100000023841858,10.1,'04/03/09','1' != None
E     97,false,2,2,2,20,2.200000047683716,20.2,'04/03/09','2' != None
E     98,true,3,3,3,30,3.299999952316284,30.3,'04/03/09','3' != None
E     99,false,4,4,4,40,4.400000095367432,40.4,'04/03/09','4' != None
E     Number of rows returned (expected vs actual): 25 != 0