[HIVE-26687] INSERT query with array<smallint> type failing with SemanticException

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 4.0.0
• Component/s: Hive
• Labels: pull-request-available
• Assignee: Unassigned
• Reporter: Manthan B Y
• Created: 02/Nov/22 09:45
• Updated: 06/Apr/23 00:18

Description

Steps to reproduce:

DROP TABLE IF EXISTS default.tbl_oGSJ;
CREATE TABLE default.tbl_oGSJ (c1 array<smallint>);
INSERT INTO default.tbl_oGSJ(c1) VALUES (array(55,54)); 

Error:

Error: Error while compiling statement: FAILED: SemanticException Line 0:-1 Cannot insert into target table because column number/types are different 'TOK_TMP_FILE': Cannot convert column 0 from array<int> to array<smallint>. (state=42000,code=40000) 

The same is the case for bigint, tinyint as well

Issue Links

• is related to: HIVE-26689 INSERT query with array<date> type failing with SemanticException (Unable to do implicit cast)
• links to: GitHub Pull Request #3923