[IMPALA-11633] Create table as select (CTAS) tests occasionally timeout for S3, Ozone

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: Impala 4.3.0
• Epic Color: ghx-label-8
• Assignee: Michael Smith
• Reporter: Kurt Deschler
• Created: 03/Oct/22 14:42
• Updated: 18/May/23 16:53
• Resolved: 02/Mar/23 22:28

Description

Several instances of this have been observed:

• metadata.test_ddl.TestAsyncDDL.test_get_operation_status_for_async_ddl, where create table test_get_operation_status_for_async_ddl_f3067b3f.alltypes_clone as select * from functional_parquet.alltypes; takes more than the allowed 3 seconds
• metadata/test_ddl.TestAsyncDDL.test_ctas times out in wait_for_state (20 seconds)
• metadata.test_load.TestAsyncLoadData.test_async_load times out in wait_for_state (10 seconds)

Need to check whether there are specific problems, or S3 and Ozone are sufficiently slower that the doubled timing for HDFS is insufficient to allow for environmental load.

Issue Links

• relates to: IMPALA-11159 TestAsyncDDLTiming.test_ctas failed in S3 build
• relates to: IMPALA-12148 Create table as select (CTAS) tests time out