[jira] [Assigned] (IMPALA-10173) Allow implicit casts from numerics to STRING when inserting into table

["Daniel Becker (Jira)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/IMPALA-10173?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Daniel Becker reassigned IMPALA-10173:
--------------------------------------

    Assignee: Daniel Becker

> Allow implicit casts from numerics to STRING 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: Daniel Becker
>            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-unsubscribe@impala.apache.org
For additional commands, e-mail: issues-all-help@impala.apache.org