You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues-all@impala.apache.org by "Tim Armstrong (JIRA)" <ji...@apache.org> on 2018/10/25 01:00:00 UTC

[jira] [Commented] (IMPALA-7371) TestInsertQueries.test_insert fails on S3 with 0 rows returned

    [ https://issues.apache.org/jira/browse/IMPALA-7371?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16663074#comment-16663074 ] 

Tim Armstrong commented on IMPALA-7371:
---------------------------------------

Just some more data points. This failed when run without codegen then passed with codegen on this run:
{noformat}
00:46:43 query_test/test_insert.py::TestInsertQueries::test_insert[exec_option: {'sync_ddl': 0, '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: text/none] FAILED
03:34:31 query_test/test_insert.py::TestInsertQueries::test_insert[exec_option: {'sync_ddl': 0, '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: text/none] PASSED
{noformat}

> TestInsertQueries.test_insert fails on S3 with 0 rows returned
> --------------------------------------------------------------
>
>                 Key: IMPALA-7371
>                 URL: https://issues.apache.org/jira/browse/IMPALA-7371
>             Project: IMPALA
>          Issue Type: Bug
>          Components: Backend
>    Affects Versions: Impala 3.1.0
>            Reporter: David Knupp
>            Assignee: Tim Armstrong
>            Priority: Critical
>         Attachments: catalogd_excerpt.INFO, impalad_excerpt.INFO
>
>
> Stacktrace
> {noformat}
> 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
> {noformat}



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-all-unsubscribe@impala.apache.org
For additional commands, e-mail: issues-all-help@impala.apache.org