[ https://issues.apache.org/jira/browse/HIVE-26689?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Manthan B Y updated HIVE-26689: ------------------------------- Affects Version/s: 4.0.0 > INSERT query with array<date> type failing with SemanticException (Unable to > do implicit cast) > ---------------------------------------------------------------------------------------------- > > Key: HIVE-26689 > URL: https://issues.apache.org/jira/browse/HIVE-26689 > Project: Hive > Issue Type: Bug > Components: Hive > Affects Versions: 4.0.0 > Reporter: Manthan B Y > Priority: Major > > *Steps to reproduce:* > {code:java} > DROP TABLE IF EXISTS default.tbl_oGSJ; > CREATE TABLE default.tbl_oGSJ (c1 array<date>); > INSERT INTO default.tbl_oGSJ(c1) > VALUES(array('2006-09-25','1980-07-19','1992-02-11'));{code} > *Error:* > {code:java} > 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<string> to array<date>. > (state=42000,code=40000){code} -- This message was sent by Atlassian Jira (v8.20.10#820010)