[HIVE-27253] Support array type when query does not produce any rows

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Component/s: CBO
• Labels: pull-request-available
• Assignee: Krisztian Kasa
• Reporter: Krisztian Kasa
• Created: 12/Apr/23 10:48
• Updated: 14/Apr/23 04:32
• Resolved: 14/Apr/23 04:32

Description

CREATE TABLE T1 (c1 int, c2 array<int>);
CREATE TABLE T2 AS SELECT * FROM T1 LIMIT 0;
describe formatted t2;

The new t2 table schema should be

POSTHOOK: Input: default@t2
# col_name            	data_type           	comment             
c1                  	int                 	                    
c2                  	array<int>          	                    

Issue Links

• relates to: HIVE-26524 Use Calcite to remove sections of a query plan known never produces rows
• links to: GitHub Pull Request #4223