[ https://issues.apache.org/jira/browse/IMPALA-10173?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Peter Rozsa updated IMPALA-10173: --------------------------------- Summary: Allow implicit casts between numeric and string types when inserting into table (was: Allow implicit casts from numerics to STRING when inserting into table) > Allow implicit casts between numeric and string types when inserting into > table > ------------------------------------------------------------------------------- > > Key: IMPALA-10173 > URL: https://issues.apache.org/jira/browse/IMPALA-10173 > Project: IMPALA > Issue Type: Improvement > Components: Frontend > Reporter: Tim Armstrong > Assignee: Peter Rozsa > Priority: Minor > Labels: 2023Q1, ramp-up, sql-language, supportability > > Impala is somewhat stricter than other engines such as Hive when it comes > into implicit casts. This avoids a lot of ambiguity and edge cases with > complex SQL, but we could consider loosening it for simple cases like > inserting into a table where the meaning/intent is pretty straightforward. > Repro > {code} > CREATE TABLE iobt ( c0 FLOAT ) ; > INSERT INTO iobt(c0) VALUES ('0'), (1562998803); > {code} > Error > {code} > AnalysisException: Incompatible return types 'STRING' and 'INT' of exprs > ''0'' and '1562998803'. > {code} -- This message was sent by Atlassian Jira (v8.20.10#820010) --------------------------------------------------------------------- To unsubscribe, e-mail: issues-all-unsubscr...@impala.apache.org For additional commands, e-mail: issues-all-h...@impala.apache.org